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

261 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
cheques213686(None) 
cheque2036661cheque_
chequer2135151chequer
chequers2234101chequers
caiques18248792caiques
calques182710192calques
casques18278982casques
cheeses123613102cheeses
chegoes1337332chegoes
cherubs1434552cherubs
chesses124112632chesses
chevies153511442chevies
chevres15379792chevres
cinques1837332cinques
cirques1836462cirques
claques18279012claques
cliques18309202cliques
cloques18268562cloques
achenes12313493ache_nes
avenues1057183avenues
barques18259643barques
basques18248673basques
bequest1837823_bequest
bisques18236893bisques
bosques18217973bosques
caciques21165373caciques
caique17318803caique_
calque17289843calque_
calqued19306523calqued
cangues10611823cangues
casque17299273casque_
casqued19235633casqued
caziques28193773caziques
ceases84427073c_eases
cedes84927333c_e_des
cees65941593c_e__es
censes83721803c_enses
cepes94424463c_e_pes
ceres75540013c_e_res
cereus85215523c_ereus
certes84623083c_ertes
ceruse83914523c_eruse
ceruses93716233c_eruses
cesses84221363c_esses
cetes75731103c_e_tes
chabuks1843733chabuks
chafes145017913ch_afes
chaines124518733chaines
chaises124317493chaises
chances145218093chances
changes134517583changes
chaoses124715123chaoses
chapes135421873ch_apes
chaqueta2242753chaqueta
chaquetas2342193chaquetas
chares115631803ch_ares
charges134615983charges
charquis2243933charquis
chases115128233ch_ases
chasses124017503chasses
cheapen14407623cheapen
cheapens15305943cheapens
cheaper144010583cheaper
cheapest1536073cheapest
cheapies1539033cheapies
cheapos14418513cheapos
cheaps134613683che_aps
cheated134416343cheated
cheater124816963cheater
cheaters133613513cheaters
cheats114519543che_ats
chebec1536963che_bec
chebecs1635013chebecs
checked193710023checked
checker18329533checker
checkers19317843checkers
checks174912703che_cks
checkups2142803checkups
cheder125113493che_der
cheders134512393cheders
chedites1438263chedites
cheek145115713che__ek
cheeked17399663cheeked
cheeks154712783che_eks
cheep125416503che__ep
cheeped153410593cheeped
cheeper143610743cheeper
cheepers15329013cheepers
cheeps135312913che_eps
cheer105420383che__er
cheered133713303cheered
cheerer123511763cheerer
cheerers13319543cheerers
cheeros123711643cheeros
cheers114518913che_ers
cheese113812763che__ese
cheesed133910683cheesed
cheesy14419193che__esy
chefed155010563che_fed
cheffed19335863cheffed
chefs136214663che__fs
chegoe1237273chegoe_
chelae113614613chelae_
chelas113817203che_las
chelates132713853chelates
chemics16349583chemics
chemise143211503chemise
chemises153211983chemises
chemos13311723che_mos
chequered2442613chequered
cherries131812993cherries
cherts115617233che_rts
cherub1337263cheru_b
chess105016923che__ss
chested133811673chested
chests114916263che_sts
chetahs15347073chetahs
cheths14389823che_ths
chetrums1543913chetrums
chevied16357483chevied
chevre14318313chevre_
chevret153310633chevret
chevrets16255323chevrets
chewed154415013che_wed
chewer145512623che_wer
chewers154111143chewers
chewier1537593chewier
chewiest16177293chewiest
chews135418513che__ws
chiaus113611313chiau_s
chiauses1336483chiauses
chicles143512503chicles
chides124620473ch_ides
chigoes1338353chigoes
childes134211273childes
chiles115425303ch_iles
chilies124218303chilies
chimes134922573ch_imes
chines115029173ch_ines
chirres123812253chirres
chirus114615693chiru_s
chives144317593ch_ives
chivies153412853chivies
choices142010613choices
chokes154917383ch_okes
chooses125717433chooses
chores114828023ch_ores
chorus115014773choru_s
choruses1339983choruses
choses115825133ch_oses
chouse116017563ch_ouse
chouses125117813chouses
chowses155611283chowses
chromes142914933chromes
chubs125412623ch__ubs
chugs115511943ch__ugs
chums125015833ch__ums
chutes114615773ch_utes
chyles144813283ch_yles
chymes165912153ch_ymes
cinque1736853cinque_
cirque1735853cirque_
claque17338563claque_
claquer18287353claquer
claquers19226203claquers
cleaves124111623cleaves
cleomes1138813cleomes
clepes104214623cle_pes
clique17289193clique_
cliqued19266683cliqued
cliquey21295693cliquey
cloque17288743cloque_
clues74623033c__lues
coenures1048683coenures
coequal1844943coequal
coequals1944313coequals
coequates2045853coequates
coerces11311943coerces
coheres122917693cohe_res
conquer1838623conquer
conquers1938223conquers
conquest1939553conquest
coquet174318013c_oquet
coquets18399893c_oquets
creases94020963creases
creates95225203creates
creches14313093creches
creeses93914623creeses
cremes104517993cre_mes
creoles9913323creoles
crepes105419343cre_pes
cresses94219813cresses
croquet1859683croquet
croquets1955213croquets
croquis1834763croquis
cues65438983c___ues
cyeses11510123cye_ses
echelles1346673echelles
exchequer3051343exchequer
exchequers3151073exchequers
exequies2444153exequies
fiques1837973_fiques
ghees95215553ghe__es
heaumes1237423_heaumes
heaves124120303_heaves
hebes105521673_he_bes
hedges115016263_hedges
heezes184211643_heezes
helves124316063_helves
hemes105031083_he_mes
henges104516463_henges
heres86245903_he_res
heroes94923833_heroes
herpes115517323_herpes
hexes155123043_he_xes
hues75235233_h__ues
marques182610863marques
masques18239363masques
mosques18256923mosques
opaques1833643opaques
piques1739093_piques
plaques18317893plaques
prequel1836343prequel
prequels1934833prequels
prevues1239263prevues
pulques1835323pulques
queues153510193que_ues
request16311023_request
revues9813903_revues
rhemes115913183rhe_mes
rhesus936203rhesu_s
rhesuses1134893rhesuses
rheums1135463rhe_ums
roques154912563_roques
sacques18106863sacques
schedules1562953schedules
schemes1489663sche_mes
segues7412073_segues
sequel1556713_sequel
sequels1665713_sequels
sheaves134412973sheaves
sheeves133911953sheeves
shelves134112093shelves
sheqel1846523sheq_el
sheqels1934753sheqels
tenues63816443_tenues
thebes115914493the_bes
theines104013233theines
themes115319253the_mes
theres96525473the_res
thermes126214613thermes
theses96517973the_ses
toques154612353_toques
torques16217513torques
tuques15358373_tuques
uniques1667443uniques
usques15126803_usques
venues95115203_venues
wheezes22306813wheezes
wheres125917443whe_res
wherves16548063wherves

Search took 7 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.406440125.6
2DLD Change Limit1340272616.15621771.8
3Display Results2612610.1102372.7
 (SQL Overall)1786912616.67226782.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.