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 “neocoo” 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.

74 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
neocon836711neocon
boocoo1039002boocoo
coocoo1069692coocoo
neocons936912neocons
beacon10511373beacon
booboo1039463booboo
boocoos1137753boocoos
boohoo1148833boohoo
bookoo1248343bookoo
coco87330603_coc_o
cocoa98517883_cocoa
cocoon10312263_cocoon
cocos95624693_cocos
coo59566363___coo
deacon9510423deacon
deco76125973de_c_o
decor84717573de_cor
decos85522123de_cos
decoy115716313de_coy
doodoo8108893doodoo
echo96615953_e_cho
escot75320083_escot
gecko124511113ge_cko
gentoo7311313gentoo
hencoop1443813hencoop
hoodoo10109983hoodoo
hoopoo1198753hoopoo
jocko184210453_jocko
kerchoo1644973kerchoo
koodoo11107773koodoo
loco67030743_loc_o
locos75822603_locos
nacho105414383n_acho
narco76718243narc_o
narcos86714203narcos
neck105423663ne_c_k
necks115119333ne_cks
nekton1036583nekton
nelson638423nelson
neology11238293neology
neon47026423ne__on
neoned7311483neoned
neons55818683neo_ns
nerol51017813ne_rol
nestor63713423nestor
netop7312343ne_top
neuron6310373neuron
newton936983newton
nicol71113293n_icol
nock106127183n_oc_k
nocks115121013n_ocks
nohow1137293n_ohow
nolo46229313n_o_lo
nolos54423353n_olos
nomoi76012533n_omoi
nomos75919743n_omos
noncom1039683noncom
noo37154043n___oo
nook85728493n_o_ok
noon47134623n_o_on
nuncio837973nuncio
poco86826153_poc_o
recon75624243re_con
recook125513923recook
recto74520803re_cto
reecho11318653reecho
rococo1036813_rococo
secco9312423se_cco
seccos1039923seccos
socko115215113_socko
telco7511873telc_o
telcos8710683telcos
velcro1144133velcro
voodoo10127533voodoo

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit112716745.09622118.5
3Display Results74740.0302466.7
 (SQL Overall)178691745.26633933.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.