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

250 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
cheque203666(None) 
chequer2135151chequer
cheques2136861cheques
caique17318802caique
calque17289842calque
casque17299272casque
cheese113812762cheese
chegoe1237272chegoe
chelae113614602chelae
chequers2234102chequers
cherub1337262cherub
chevre14318312chevre
cinque1736852cinque
cirque1735852cirque
claque17338562claque
clique17289192clique
cloque17288742cloque
achene11313813ache_ne
avenue957953avenue
barque17239553barque
basque17259083basque
bisque17257843bisque
bosque17257733bosque
cacique20205693cacique
caecum1238183caecum
caiques18248793caiques
calqued19306523calqued
calques182710193calques
cangue91012443cangue
casqued19235633casqued
casques18278983casques
cazique27194033cazique
cease75227653c_ease
cecum11611843c_ecum
cede74928763c_e_de
cee55952703c_e__e
cense75121403c_ense
cepe84926653c_e_pe
cere66741473c_e_re
ceruse83914523c_eruse
cete64934783c_e_te
chabuk1734673chabuk
chaetae1238603chaetae
chafe135117353ch_afe
chaine115119223chaine
chaise114916413chaise
chance134617093chance
change124116753change
chape125221143ch_ape
chaqueta2242753chaqueta
chare105231983ch_are
charge125114213charge
charqui2143993charqui
chase105127123ch_ase
chasse115114603chasse
chaste114617393chaste
cheap126915943che_ap
cheapen14407623cheapen
cheaper144010583cheaper
cheapie1437563cheapie
cheapo134810083cheapo
cheaps134613683cheaps
cheat105732453che_at
cheated134416343cheated
cheater124816953cheater
cheats114519543cheats
chebec1536963chebec
check164714713che_ck
checked193710023checked
checker18329533checker
checks174912703checks
checkup2043323checkup
cheder125113493cheder
chedite1338863chedite
cheek145115713che_ek
cheeked17399663cheeked
cheeks154712783cheeks
cheeky18448613cheeky
cheep125416503che_ep
cheeped153410593cheeped
cheeper143610743cheeper
cheeps135312913cheeps
cheer105420383che_er
cheered133713293cheered
cheerer123511753cheerer
cheero114712933cheero
cheers114518913cheers
cheery144913153cheery
cheesed133910683cheesed
cheeses123613103cheeses
cheesy14419193cheesy
chef125125623che__f
chefed155010563chefed
cheffed19335863cheffed
chefs136214663che_fs
chegoes1337333chegoes
chela103916803che_la
chelas113817203chelas
chelate122914893chelate
chemic153012093chemic
chemise143211503chemise
chemo12313633che_mo
chemos13311723chemos
chequered2442613chequered
cherry144810763cherry
chert105232103che_rt
cherts115617233cherts
cherty144612473cherty
cherubs1434553cherubs
chess105016923che_ss
chesses124112633chesses
chest104926143che_st
chested133811673chested
chests114916263chests
chesty144610503chesty
chetah14399583chetah
cheth135013823che_th
cheths14389823cheths
chetrum1445333chetrum
chevied16357483chevied
chevies153511443chevies
chevres15379793chevres
chevret153310633chevret
chevy16479993che_vy
chew126622133che__w
chewed154415013chewed
chewer145512613chewer
chewier1537583chewier
chews135418513che_ws
chewy165011903che_wy
chez184519023che__z
chiaus113611303chiaus
chicle134312543chicle
chide115321013ch_ide
chigoe1237533chigoe
childe124711213childe
chile105626893ch_ile
chime125322593ch_ime
chine105231723ch_ine
chirre114111853chirre
chiru105317153chiru_
chirus114615693chirus
chive135117623ch_ive
choice132010523choice
choke145118023ch_oke
choose115116143choose
chore105126763ch_ore
chorus115014763chorus
chose105925403ch_ose
chouse116017563chouse
chowse144711753chowse
chrome133214813chrome
chub115516413ch__ub
chug105914113ch__ug
chum116318003ch__um
chute104316463ch_ute
chyle134913483ch_yle
chyme156512503ch_yme
cinques1837333cinques
cirques1836463cirques
claquer18287343claquer
claques18279013claques
cleave114212513cleave
cleome1039083cleome
clepe94617383cle_pe
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
cliquy20324713cliquy
cloques18268563cloques
clue65324533c__lue
coenure968143coenure
coequal1844933coequal
coequate1946153coequate
coerce10310403coerce
cohere112716993cohe_re
conquer1838613conquer
coquet174318013c_oquet
crease85519573crease
create85126373create
creche13310763creche
creese84014333creese
creme94319323cre_me
creole8913723creole
crepe95520723cre_pe
croquet1859683croquet
cue57544183c___ue
echelle1246623echelle
exchequer3051343exchequer
exequy2542523exequy
fique1739143_fique
ghee85726113ghe__e
heaume1137543_heaume
heave114521813_heave
hebe96424703_he_be
hedge105317333_hedge
heeze175313483_heeze
helve115018093_helve
heme95034413_he_me
hence104920043_hence
henge94819823_henge
here76447103_he_re
hue66642303_h__ue
manque17259513manque
marque172410503marque
masque17249383masque
mosque17287163mosque
opaque1734213opaque
pique16410173_pique
plaque17317643plaque
prequel1836343prequel
prevue1179163prevue
pulque1736213pulque
queue143711233que_ue
revue81114453_revue
rheme106214053rhe_me
rhesus936203rhesus
rheum1038843rhe_um
risque15227453risque
roque144812133_roque
sacque17107113sacque
schedule1443243schedule
scheme1379633sche_me
segue6314413_segue
sequel1556713_sequel
sheave124514003sheave
sheeve123412843sheeve
shelve124012763shelve
sheqel1846523sheqel
thebe107515433the_be
thecae11299653thecae
thee78039063the__e
theine94814923theine
theme105921733the_me
thence112010843thence
there87527393the_re
therme115814993therme
these86519013the_se
toque145113093_toque
torque15237673torque
tuque14469193_tuque
ubique1784883ubique
unique1558163unique
usque14137733_usque
venue84918213_venue
whee105429593whe__e
wheeze21276813wheeze
whence14187923whence
where117019423whe_re
wherve15568113wherve

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.1401276364.3
2DLD Change Limit1127162506.81316544.3
3Display Results2502500.1561602.6
 (SQL Overall)1786912507.10925135.9
 
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.