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

240 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
cirque173585(None) 
cinque1736851cinque
cirques1836461cirques
barque17239552barque
bisque17257842bisque
caique17318802caique
calque17289842calque
casque17299272casque
cheque2036662cheque
cinques1837332cinques
circle1039702circle
circus104310592circus
cire65836382cir__e
cirrus8349172cirrus
claque17338562claque
clique17289192clique
cloque17288742cloque
fique1739142fi_que
marque172410502marque
pique16410172pi_que
piroque1844352piroque
risque15227452risque
torque15237672torque
virtue9358672virtue
accrue1035823accr_ue
airbus848343airbus
argue64818443_argue
baroque1835113baroque
barques18259643barques
basque17259083basque
birdie94013783birdie
bireme10310143bireme
birkie124110133birkie
birle75023633bir_le
birse74517403bir_se
bisques18236893bisques
bosque17257733bosque
briquet1838833briquet
cacique20205693cacique
caiques18248793caiques
calqued19306523calqued
calques182710193calques
cangue91012453cangue
carafe115416163carafe
carate84734003carate
care66968373car__e
carful11610973carful
caribe103416753caribe
carle74535703car_le
carnie84421093carnie
carouse9614423carouse
carpus105514303carpus
carse74934333car_se
carte75940423car_te
carve106227753car_ve
casqued19235633casqued
casques18278983casques
cazique27194033cazique
cerate84829463cerate
cercus105013153cercus
cere66741473cer__e
cereus85215523cereus
cerise84822043cerise
cerite84724873cerite
cerium10313773cerium
cerous85821203cerous
ceruse83914523ceruse
charqui2144003charqui
chequer2135153chequer
cheques2136863cheques
chirre114111853chir_re
chirrup14123833chirrup
chiru105317153chir_u_
chirus114615693chir_us
chrome133214813chrome
ciboule1145093ciboule
cicale10314503cicale
cilice103213353cilice
cilium104311373cilium
cine66242953ci__ne
circa9311403cir_ca
circled1237583circled
circler1136423circler
circles1139903circles
circlet11311473circlet
circuit1148833circuit
circuses1238253circuses
circusy14374593circusy
cires74932913cir_es
cirrate92413493cirrate
cirri7710723cir_ri
cirrose937473cirrose
cirrous93111063cirrous
cistus84611343cistus
cite65640353ci__te
citole8311503citole
citrate92216803citrate
citrine92514023citrine
citrous93112993citrous
citrus83610923citrus
civie103716353ci_vie
claquer18287353claquer
claques18279013claques
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
cliquy20324713cliquy
cloques18268563cloques
clue65324533c__lue
conquer1838623conquer
coquet174318013c_oquet
corbie103618203corbie
core67263113cor__e
corium10315723corium
cornu75921323cornu_
cornua85411903cornua
cornus84816563cornus
cornute939643cornute
corpse104013413corpse
corpus106015293corpus
corrie83621233corrie
corse75036183cor_se
corvee114320093corvee
crake114823523c_rake
crane75331603c_rane
crape96128443c_rape
crate76537403c_rate
crave105626313c_rave
craze165221463c_raze
creme94319323c_reme
crepe95520723c_repe
crime94822693c_rime
cringe93515483cringe
crinum1039333crinum
cripe95521143c_ripe
critique1943033critique
crone75231333c_rone
croquet1859683croquet
crore74922873c_rore
croup95616783c_roup
croupe105114433c_roupe
crouse84619373c_rouse
croute84617273c_route
croze164719453c_roze
cru57129563c_r_u_
crud75219613c_r_ud
crude86018573c_rude
cruel74815903c_r_uel
cruet74831843c_r_uet
crus65828483c_r_us
cruse75726103c_ruse
crux135415003c_r_ux
cue57544183c___ue
curare84916953curare
curate85226243curate
curdle95514313curdle
cure66149123cur__e
curiae84518373curiae
curie74533043cur_ie
curite85222943curite
curium10312503curium
currie84317263currie
curse75829143cur_se
curule83614123curule
curve104920023cur_ve
dirdum1036033dirdum
dire56644153dir__e
dirge75117073dir_ge
fiques1837973fi_ques
fire76245603fir__e
gigue71210673gi_gue
girdle82110463girdle
girlie73711463girlie
grue55825713_gr_ue
hire75538973hir__e
hiree85427803hir_ee
hirple11158973hirple
hirsle9159573hirsle
hirsute1084523hirsute
imbue939483_imbue
indue63516673_indue
irade65618153_irade
irate55627983_irate
ire36943183_ir__e
irone55126363_irone
issue559213_issue
kirtle10309473kirtle
lire47845303lir__e
manque17259513manque
marquee18218583marquee
marques182610863marques
masque17249383masque
mirage92313653mirage
mire66748243mir__e
miscue10412223miscue
morgue938113morgue
mosque17287163mosque
opaque1734213opaque
parquet18311583parquet
perdue93912633perdue
perique1837523perique
picquet2047743picquet
piqued1836213pi_qued
piques1739093pi_ques
piquet17412353pi_quet
pirate82322883pirate
pirogue1045413pirogue
piroques1944353piroques
plaque17317643plaque
pulque1736213pulque
pursue84512253pursue
roque144812133_roque
roue45941743__roue
rue35549263__r_ue
sacque17107113sacque
silique1645643silique
sire46150423sir__e
siree55238813sir_ee
sirree64017343sirree
sirup74014913sir_up
sprue74717633spr_ue
tirade7311693tirade
tire46143363tir__e
tissue637333tissue
toque145113093_toque
torqued17224893torqued
torquer16205323torquer
torques16217513torques
true46725853_tr_ue
tuque14469193_tuque
ubique1784883ubique
unique1558163unique
usque14137733_usque
virgule1144283virgule
virile9313433virile
virtu85314093virtu_
virtues10338023virtues
virtus94310143virtus
virus85316843vir_us
wire75839823wir__e

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.780229091.0
2DLD Change Limit1127162406.67016899.0
3Display Results2402400.1601500.0
 (SQL Overall)1786912407.61023481.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.