Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “noncolas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
noncolas104861(None) 
noncola948291noncola_
dongolas1045342dongolas
gondolas1046192gondolas
nonclass1046242nonc_lass
noncolor1046512noncolor
noncolors1147032noncolors
noncoms1139202nonco_ms
nonpolar1046282nonpolar
nonsolar847082nonsolar
boffolas1642833boffolas
canolas9313993can_olas
cocoas104915743co_co_as
colas75436773___colas
conceals123111013conceals
conchas144013313conc_has
concocts1138633concocts
concords1358593concords
concours1239473concours
condoles113015803condoles
consoles103216153consoles
consols92914073consol_s
dongola945473dongola_
foveolas14135113foveolas
gondola946663gondola_
mandolas1139133mandolas
mongols103310823mongol_s
monocles12310673monocles
moolas83615593mo__olas
moviolas1344513moviolas
narcomas1246043narcomas
nicols8810243n_icol_s
nonas55126653non___as
nonbooks1446123nonbooks
noncash1245163nonc__ash
nonces84418833nonc__es
noncoital1148583noncoital
noncom1039683nonco__m
noncombat1555443noncombat
noncore9411953nonco_re
nondollar1043713nondollar
nonfocal1346443nonfocal
nonlocal1047513nonlocal
nonlocals1144803nonlocals
nonloyal1145123nonloyal
nonmodal1146593nonmodal
nonmoral1049233nonmoral
nonoral7313603non_oral
nonplay1246683non_play
nonplays1344893non_plays
nonplus936183non_plus
nonroyal1145753nonroyal
nonsolid957413nonsolid
nonsolids1045383nonsolids
nontonal849743nontonal
nonuples1056533nonuples
nonvocal1346123nonvocal
nonvocals1444143nonvocals
nonwords1247463nonwords
nonyls957853non_yl_s
novellas1176343novellas
nuncles939843nunc_les
roseolas8107163roseolas
tombolas1246023tombolas
zonulas1637023zon_ulas

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit146162657.83018666.9
3Display Results65650.0302166.7
 (SQL Overall)178691658.28021581.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.