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

160 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
crusade103605(None) 
crusaded1244231crusaded
crusader1144271crusader
crusades1146331crusades
crusado1043921crusado
couvade1335062couvade
croustade1243942croustade
crude86018572cru__de
crunode1034712crunode
crusaders1243452crusaders
crusadoes1243042crusadoes
crusados1153542crusados
cruse75726102crus__e
crushed134111972crushed
crusted103712762crusted
cruzado1941942cruzado
arcade91013643ar_cade
aubade939223_aubade
brigade1136493brigade
brocade1238533brocade
brushed133811213brushed
brusque1843703brusque
bursae84515603bursa_e
bursate94111203bursate
cade76443913c___ade
camisade1374823camisade
cascade12118603cascade
caudad10157673caudad_
caudate10311353caudate
causable1239973causable
causal81413203causa_l
causals91411183causals
cause75225353caus__e
caused95117043caused_
ceruse83914523cerus__e
cerusite1047763cerusite
chamade15138453chamade
charade13129913charade
clade85821013c__lade
cockade1638133cockade
comade114415323c_omade
comrade12139213comrade
corrade101111043corrade
corsage1039803corsage
coruscate1346053coruscate
coude85022633cou__de
courage10310993courage
couvades1435613couvades
cradle93313163cr__adle
crake114823523cr__ake
crane75331603cr__ane
crape96128443cr__ape
crashed134214213crashed
crate76537403cr__ate
crave105626313cr__ave
craze165221463cr__aze
crease85519573cr_ease
creased104315593creased
create85126383cr_eate
cremate113816183cremate
crenate93317113crenate
crested103416543crested
crispate1246913crispate
crisped124010113crisped
cristae9310613cristae
cristate10310603cristate
crosse85216313cros_se
crossed105313903crossed
crouse84619373crous__e
croustades1344083croustades
cruciate1287313cruciate
crud75219613cru__d_
crudded1235733cru_dded
cruddy1334193cru_ddy
cruder95612383cru__der
crudes96218623cru__des
cruds85815853cru__ds
cruise84314043cru_ise
cruised103710223cruised_
crumbed14378473crumbed
crumble133410403crumble
crummie1336153crummie
crumped144311223crumped
crumple13368363crumple
crunodes1144973crunodes
crura7312583crura__
crural8610633crura_l
crus65828483crus___
crusading1344113crusading
cruses88127713crus_es
cruset84425093crus_et
crusets93811043crusets
crush106815993crus__h
crushable1645263crushable
crusher124412323crusher
crushes124215133crushes
crusily12199093crusily
crust75827663crus__t
crustacea1342663crustacea
crustal939023crustal
crustier10259533crustier
crustose1045503crustose
crusts84916543crus_ts
crusty114911343crus_ty
cruzadoes2141743cruzadoes
cruzados2041973cruzados
cubage1178273c_ubage
curare84916953c_urare
curate85226243c_urate
curbside1344673curbside
curiae84518373curia_e
curse75829143curs__e
cursed94321253cursed_
curseder1145343curseder
cursive1237833cursive
curtate9312643curtate
cuspate1138233c_uspate
cusped114312043c_usped
cussed94917123c_ussed
druse64817663drus__e
grade75126093gr__ade
grenade938413grenade
grushie1135813grushie
irade65618153ir__ade
passade1039233passade
persuade1145853persuade
pesade9311103_pesade
prebade12310283prebade
prefade1339013prefade
premade12311443premade
presage10312293presage
presale9416353presale
preside10715613preside
prude84615973pru__de
remade94316983_remade
resale64025543_resale
reside74224933_reside
respade1039573_respade
roulade857003roulade
rubace10310173_rubace
rude55632783_ru__de
rugae65114763_ruga_e
rugate75813813_rugate
ruse45938933_rus__e
rushed104419863_rushed
rushee93818773_rushee
rusine63916593_rusine
rusted75020923_rusted
rustle63615413_rustle
sade55544473___sade
sausage847193sausage
torsade837593torsade
trade65026043tr__ade
tribade1037293tribade
trussed84010033trussed
trusted83412793trusted
trustee73514443trustee
tsade64311123__tsade
ursae55214453ur_sa_e
usage6410213__usage

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 Filter1786911340270.810220606.2
2DLD Change Limit1340271607.87617017.1
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.74920424.2
 
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.