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 “rococo” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
rococo103681(None) 
rococos1145901rococos
coco87330602__coco
recock145112722recock
acock132110213_acock
bocce114313113boc_ce
bocci113512713boc_ci
bonobo1037143bonobo
boocoo1039003boocoo
brocoli1146353brocoli
bronco10179493bro_nco
brooch13368443bro_och
coca88030643__coca
cocci82812673coc_ci
cock126332903__cock
cocoa98517883coco_a
cocoas104915743cocoas
cocoon10312263cocoon
cocos95624693coco_s
coho97524493__coho
concoct10312903concoct
coo59566363__co_o
cooch124916833co_och
coocoo1069693coocoo
decoct11313783decoct
gorcock1643653gorcock
hooch135813703ho_och
jocko184210453joc_ko
jocose1537103jocose
loco67030743__loco
locoed94312193locoed
locoes85516583locoes
locofoco1551403locofoco
locos75822603loco_s
macaco1247853macaco
moloch1356483moloch
monocot11412013monocot
mooch125313613mo_och
morocco1343523morocco
ovolo8339173_ovolo
poco86826153__poco
pocoson1156753pocoson
pooch124815303po_och
protocol1246473protocol
raccoon1176163raccoon
racon75422143raco_n
racons84319343racons
racoon83814473racoon
rebozo1737323rebozo
recce9514563rec_ce
recoal84117973recoal
recoat84024273recoat
recocks154711463recocks
recode93618713recode
recoil84016723recoil
recoin84320293recoin
recolor978693recolor
recomb1238873recomb
recon75624243reco_n
recons84922993recons
recook125513923recook
recopy1339043recopy
record96117423record
recork126315483recork
recoup10810373recoup
recto74520803rec_to
redock134311543redock
relock124713523relock
roach105717003ro_ach
roadeo7510323roadeo
robalo838923robalo
robot7325973robo_t
robots8313143robots
roc520243253r__oc_
rochet115423003rochet
rock105735183r__ock
rocked135022323rocked
rocker124319573rocker
rocket125425283rocket
rockoon1345653rockoon
rocks114626413roc_ks
rocky144513853roc_ky
rocs65533663r__ocs
rodeo65921093ro_deo
romano84912943romano
romeo73719703ro_meo
rondo65218373ro_ndo
rood56733003ro_o_d
roods65125283ro_ods
roof75738833ro_o_f
roofs85321153ro_ofs
rook85532033ro_o_k
rooks95325043ro_oks
rooky126117623ro_oky
room66235083ro_o_m
rooms75324683ro_oms
roomy107118063ro_omy
roose56127093ro_ose
roost55730933ro_ost
root45655923ro_o_t
roots55933673ro_ots
rooty86423023ro_oty
roscoe839763rosco_e
roscoes9310923roscoes
rosolio746983rosolio
rotch105815933ro_tch
roto45935053r__oto
rotor55519733roto_r
rotors64917933rotors
rotos56027883roto_s
rowlock1654783rowlock
scooch13228123scooch
secco9312423sec_co
sirocco1143033siroc_co
socko115215113soc_ko
uncock1438563uncock
zocalo1735803zocalo

Search took 8 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.233766914.2
2DLD Change Limit1127161176.82616512.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.10525150.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.