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

273 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
cirques183646(None) 
cinques1837331cinques
cirque1735851cirque_
barques18259642barques
bisques18236892bisques
caiques18248792caiques
calques182710192calques
casques18278982casques
cheques2136862cheques
cinque1736852cinque_
circles1139902circles
circus104310592circu_s
circuses1238252circuses
cires74932912cir__es
cirrus8349172cirru_s
claques18279012claques
cliques18309202cliques
cloques18268562cloques
fiques1837972fi_ques
marques182610862marques
piques1739092pi_ques
piroques1944352piroques
torques16217512torques
virtues10338022virtues
accrues1135323accr_ues
airbus848343airbu_s
airbuses1067073airbuses
argues74516413_argues
baroques1934863baroques
barque17239553barque_
basques18248673basques
birches143412323birches
birdies104016213birdies
biremes1138773biremes
birkies133712433birkies
birles84920643bir_les
birses84717733bir_ses
bisque17257843bisque_
bosques18217973bosques
briquet1838833briquet
briquets1934853briquets
caciques21165373caciques
caique17318803caique_
calque17289843calque_
calqued19306523calqued
cangues10611823cangues
carafes125015703carafes
carates95630613carates
cares77369183car__es
carfuls1249133carfuls
cargoes104415223cargoes
caribes113715643caribes
carices114220953carices
caries85147623car_ies
carles85435083car_les
carnies94123963carnies
carouse9614423carouse
carouses10614503carouses
carpus105514303carpu_s
carries94328013carries
carses85233653car_ses
cartes86239473car_tes
carves115128453car_ves
casque17299273casque_
casqued19235633casqued
caziques28193773caziques
cerates95428253cerates
cercus105013153cercu_s
ceres75540013cer__es
cereus85215523cereu_s
cereuses1049243cereuses
cerises94722253cerises
cerites94823433cerites
ceriums1139473ceriums
cerous85821203cerou_s
certes84623083cer_tes
ceruse83914523cer_use
ceruses93716233ceruses
charquis2243933charquis
cheque2036663cheque_
chequer2135153chequer
chequers2234103chequers
chirres123812253chir_res
chirrups15133043chirrups
chirus114615693chir_u_s
chromes142914933chromes
ciboules1244533ciboules
cilices113814023cilices
cimices13279803cimices
cinches144215773cinches
cines75239683ci__nes
circle1039703circle_
circled1237583circled
circler1136423circler
circlers1235353circlers
circlet11311473circlet
circlets1235663circlets
circuit1148833circuit
circuits1246023circuits
circusy14374593circusy
cire65836373cir__e_
cirrose937473cirrose
cirrous93111063cirrous
ciscoes113610733ciscoes
cissies94116153cissies
cistus84611343cistu_s
cistuses1038283cistuses
cites74435593ci__tes
cities84524853ci_ties
citoles9312553citoles
citrates102315093citrates
citrines102513133citrines
citrous93112993citrou_s
citrus83610923citru_s
citruses1037483citruses
civies114116443ci_vies
civvies1555843civvies
claque17338563claque_
claquer18287353claquer
claquers19226203claquers
clique17289193clique_
cliqued19266683cliqued
cliquey21295693cliquey
cloque17288743cloque_
clues74623033c__lues
conquer1838623conquer
conquers1938223conquers
conquest1939553conquest
coquet174318013c_oquet
coquets18399893c_oquets
corbies113520123corbies
cores76361853cor__es
cornus84816563cornu_s
cornuses10310033cornuses
corpses113913803corpses
corpus106015293corpu_s
corpuses12310063corpuses
corries94026793corries
corses84433463cor_ses
corvees124613793corvees
corves115122523cor_ves
crakes124921813c_rakes
cranes84330753c_ranes
crapes104727693c_rapes
crases85532313c_rases
crates85736063c_rates
craves115825393c_raves
crazes174720133c_razes
cremes104517993c_remes
crepes105419343c_repes
cries75438403c_r_ies
crimes105521583c_rimes
cringes103215503cringes
crinums1135863crinums
cripes105120873c_ripes
crises84529433c_rises
critiques2042593critiques
crones84729243c_rones
croquet1859683croquet
croquets1955213croquets
croquis1834763croquis
crores86121163c_rores
croupes114613103c_roupes
croups104312553c_roups
crouse84619363c_rouse
croutes94815653c_routes
crozes174417663c_rozes
cruces105117543c_ruces
crudes96218623c_rudes
cruds85815853c_r_uds
cruel74815903c_r_uel
cruet74831843c_r_uet
cruets85314953c_r_uets
crus65828483c_r_u_s
cruse75726103c_r_use
cruses88127713c_ruses
cruxes154911563c_ruxes
cues65438983c___ues
curares94916853curares
curates95323833curates
curches143512743curches
curdles103814573curdles
cures75645433cur__es
curies84934023cur_ies
curites93919863curites
curiums1138503curiums
curries93723163curries
curses85328273cur_ses
curves114619283cur_ves
dirdums1134383dirdums
dirges84915103dir_ges
dirties83119383dirties
fique1739143fi_que_
fires85740753fir__es
gigues8129003gi_gues
girdles92210003girdles
girlies83013703girlies
girshes11248293girshes
grues65721963_gr_ues
hirees95117293hir_ees
hires86134343hir__es
hirples12149643hirples
hirsles101510073hirsles
imbues1037983_imbues
indues73515263_indues
inquest1638603_inquest
irades74517393_irades
ires45639283_ir__es
irides74519123_irides
irises64221173_irises
irones64724013_irones
issues648803_issues
kirtles11309663kirtles
marque172410503marque_
marquee18218583marquee
marquees19206243marquees
marquess19204953marquess
marquis18247063marquis
masques18239363masques
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
miscues11312393miscues
morgues1038273morgues
mosques18256913mosques
opaques1833643opaques
parquet18311583parquet
parquets1936413parquets
perdues103511333perdues
periques1937653periques
picquet2047743picquet
picquets2143733picquets
pique16410173pi_que_
piqued1836213pi_qued
piquet17412353pi_quet
piquets1836603pi_quets
pirates93020333pirates
pirogues1135473pirogues
piroque1844353piroque_
plaques18317893plaques
pulques1835323pulques
pursues94111373pursues
risque15227453risque_
roques154912563_roques
roues56039353__roues
rues46044483__r_ues
sacques18106863sacques
siliques1745353siliques
sirees64624583sir_ees
sires55945373sir__es
sirrees73410573sirrees
sirups83710533sir_ups
sprues84515763spr_ues
tirades8311723tirades
tires55437493tir__es
tissues737463tissues
toques154612353_toques
torque15237673torque_
torqued17224893torqued
torquer16205323torquer
torquers17204303torquers
trues54925323_tr_ues
tuques15358373_tuques
uniques1667443uniques
usques15126803_usques
vires84529683vir__es
virgules1244333virgules
viroses10310533viroses
virtue9358673virtue_
virtus94310143virtu_s
virus85316843vir_u_s
viruses1039413viruses
wires86034913wir__es

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 Filter1786911340270.563317390.8
2DLD Change Limit1340272736.70319995.1
3Display Results2732730.0932935.5
 (SQL Overall)1786912737.35924282.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.