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

468 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
circle103970(None) 
circled1237581circled
circler1136421circler
circles1139901circles
circlet11311471circlet
birle75023632bir_le
carcel105018672carcel
carle74535702car_le
chicle134312542chicle
cicale10314502cicale
circa9311402circ_a
circlers1235342circlers
circlets1235662circlets
circus104310592circus
cire65836372cir__e
cirque1735852cirque
citole8311502citole
coracle112011722coracle
curdle95514312curdle
curule83614122curule
cycle1239522c_ycle
encircle1243942encircle
girdle82110462girdle
hirple11158972hirple
hirsle9159572hirsle
icicle1036582icicle
kirtle10309472kirtle
miracle1138842miracle
recircle1244432recircle
virile9313432virile
aircrew12113913aircrew
airhole1048273airhole
airily93014823airily
aisle55223193ai_sle
argle65421563_argle
auricle9139813auricle
bible95119423bi_ble
bice86235563bi_c_e
bicycle1643993bicycle
bile66147183bi__le
bindle94516263bindle
binocle1136493binocle
birch124914023birc_h
birched15349913birched
birchen14347883birchen
birches143412323birches
birdie94013783birdie
bireme10310143bireme
birkie124110133birkie
birl65830473bir_l_
birled94416993bir_led
birler85715083bir_ler
birles84920643bir_les
birls74023163bir_ls
birse74517403bir_se
boucle103712783boucle
brickle15279933brickle
bricole112810493bricole
bridle94115463bridle
burble104617703burble
burgle94815863burgle
cable95329913c_able
cache125122483c_ache
cackle143416923cackle
cajole154011183cajole
calicle113111433calicle
calycle14245833calycle
cancel105316683cancel
candle94321483candle
cantle84522153cantle
caracole12310353caracole
carafe115416163carafe
carate84734003carate
carcase11312733carcase
carcels114516063carcels
care66968373car__e
caribe103416753caribe
cariole9818343cariole
carl65144783car_l_
carles85435083car_les
carls77037423car_ls
carnie84421093carnie
caroche1469243caroche
carol75128613carol_
caroled103717683caroled
caroler93816753caroler
caroli85918233caroli
carols85124983carols
carpale113414353carpale
carpel105418473carpel
carrel84718633carrel
carse74934333car_se
carte75940423car_te
cartel85022533cartel
caruncle1244713caruncle
carve106227753car_ve
carvel114817573carvel
castle84918963castle
cattle85118903cattle
caudle93912913caudle
cenacle1139123cenacle
cerate84829463cerate
cercal10314123cercal
cerci93716393cerc_i
cercis104614493cercis
cercus105013153cercus
cere66741473cer__e
cerise84822043cerise
cerite84724873cerite
ceruse83914523ceruse
chicles143512503chicles
chicly16429203chicly
chile105626893c_hile
chiral114614413chiral_
chirre114111853chir_re
chorale124313353chorale
chortle124210443chortle
chrome133214813chrome
chuckle1836443chuckle
chyle134913483c_hyle
cibol9512023cibol_
cibols1039523cibols
ciboule1145093ciboule
cicala10310053cicala
cicely1338833cicely
cilice103213353cilice
cinch124516243cinc_h
cinched153910863cinched
cinches144215773cinches
cine66242943ci__ne
cineole91010003cineole
cinque1736853cinque
circling1338423circling
circuit1148833circuit
circular1247903circular
circulate13810433circulate
circuses1238253circuses
circusy14374593circusy
cires74932913cir_es
cirques1836463cirques
cirrate92413483cirrate
cirri7710723cir_ri
cirrose937473cirrose
cirrus8349173cirrus
cisco95112133cisc_o
ciscoes113610733ciscoes
ciscos104711133ciscos
citable11313463citable
cite65640343ci__te
citola838393citola
citoles9312553citoles
citral81113883citral_
citrals91111663citrals
citrate92216793citrate
citrine92514023citrine
civie103716353ci_vie
civil103411933civil_
cliche133712453cliche
cloche134312373cloche
cobble123615263cobble
coble94823173c_oble
cockle143913573cockle
coddle104713853coddle
coerce10310403coerc_e
coffle14359043coffle
cole66956113c__ole
coracles121811163coracles
coral76033453coral_
corals85325143corals
corbel103715973corbel
corbie103618203corbie
core67263113cor__e
cormel103815603cormel
cornel84020053cornel
cornicle1258783cornicle
corpse104013403corpse
corrie83621213corrie
corse75036183cor_se
corslet9318063corslet
coruler9311713coruler
corvee114320093corvee
couple104415963couple
crackle153611253crackle
cradle93313163cradle
crake114823523c_rake
crane75331603c_rane
crape96128443c_rape
crate76537403c_rate
crave105626313c_rave
craze165221463c_raze
creche13310763creche
creel75121483c_reel
creme94319323c_reme
creole8913723creole
crepe95520723c_repe
crick135118753cric_k
cricked164814283cricked
cricket154716953cricket
crickey18418143crickey
cricks144316053cricks
crime94822693c_rime
crimple13408693crimple
cringe93515483cringe
cringle103010353cringle
crinkle13359413crinkle
cripe95521143c_ripe
cripple13378583cripple
crone75231333c_rone
crore74922863c_rore
croze164719453c_roze
crude86018573c_rude
cruel74815903c_ruel
cruse75726103c_ruse
cubicle1337003cubicle
cuddle104414533cuddle
cuittle946403cuittle
cupule103410723cupule
curable112414513curable
curare84916953curare
curate85226243curate
curch124415413curc_h
curches143512743curches
curdled113910663curdled
curdler103511563curdler
curdles103814573curdles
cure66149123cur__e
curiae84518373curiae
curie74533033cur_ie
curite85222943curite
curl66035053cur_l_
curled95021653cur_led
curler85221323cur_ler
curlew114010903cur_lew
curls74927103cur_ls
curly105321233cur_ly
curricle12145933curricle
currie84317253currie
curse75829143cur_se
curtly1149283curtly
curve104920023cur_ve
cuticle1138233cuticle
cuttle84113893cuttle
cycled1436543c_ycled
cycler1335913c_ycler
cycles1339303c_ycles
cyclo1237703c_yclo
darkle113813943darkle
dartle73714833dartle
dibble114013843dibble
dice75841893di_c_e
diddle94915213diddle
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dipole91112853dipole
dire56644143dir__e
direly10311553direly
dirge75117073dir_ge
dirl57430023dir_l_
dirled84514903dir_led
dirls64720503dir_ls
encircled1443333encircled
encircles1343923encircles
farce104925323farc_e
farcie114816473farcie
farle86929243far_le
ferule93413203ferule
fiacre1137623fiacre
fice95737113fi_c_e
fiche134616743fi_che
fickle153912973fickle
fiddle113613383fiddle
fierce11348913fierc_e
file75446643fi__le
fille84327403fi_lle
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fire76245593fir__e
firmly1436663firmly
fizzle17369713fizzle
force105324273forc_e
garble94118453garble
gargle84215463gargle
giggle94313513giggle
girdled10217453girdled
girdler9227313girdler
girdles92210003girdles
girl56226553gir_l_
girlie73711463girlie
girls64518393gir_ls
girly94415293gir_ly
girolle835793girolle
grille74315743grille
gurgle83912473gurgle
higgle113811743higgle
hirable121612313hirable
hircine1239143hircine
hire75538963hir__e
hiree85427803hir_ee
hirpled13157133hirpled
hirples12149643hirples
hirsel9138683hirsel
hirsled11118113hirsled
hirsles101510073hirsles
hurdle103712793hurdle
hurtle93512943hurtle
ice56737243_i_c_e
icicled1234293icicled
icicles1135943icicles
idle55423763_i_dle
ingle64120433_ingle
inkle94515833_inkle
irade65618153_irade
irate55627983_irate
ire36943173_ir__e
irone55126363_irone
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jiggle153811993jiggle
jingle143815223jingle
kibble143910953kibble
kindle114414233kindle
kirtled12287033kirtled
kirtles11309663kirtles
kittle104012173kittle
liable81415813liable
lice66045063li_c_e
ligule74010833ligule
lire47845293lir__e
lisle53916723li_sle
little63312163little
macle96127003_macle
marble104219103marble
marcel103714853marcel
merle75824373mer_le
mice87442233mi_c_e
miche126219243mi_che
mickle143715133mickle
middle103414983middle
miggle104012113miggle
mile66352573mi__le
mille75029133mi_lle
mince95325233minc_e
mingle93518783mingle
miracles1238333miracles
mirage92313653mirage
mire66748233mir__e
miscue10412223miscue
misrule939353misrule
mizzle16279993mizzle
morale85220553morale
muscle10310973muscle
myrtle1135733myrtle
nibble103713283nibble
nice65534713ni_c_e
niche105016793ni_che
nickle123814483nickle
niece74814503niec_e
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nitrile73011373nitrile
nuncle839363nuncle
oracle84313293oracle
oriole6814293oriole
orle45630463_or_le
parcel103915473parcel
parle75836163par_le
parole84425253parole
percale11314083percale
pice84641093pi_c_e
pickle144215653pickle
piddle103514913piddle
piece96717993piec_e
pierce104010393pierc_e
piffle14418233piffle
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinocle1138143pinocle
pinole83218783pinole
pintle83818263pintle
pirate82322883pirate
pizzle16279493pizzle
price93725413pric_e
prickle153611013prickle
prole74527793_prole
purfle112511183purfle
purple102712673purple
rale45050563__rale
recircled1443523recircled
recircles1344433recircles
rice64942913ri_c_e
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533__rile
rille55728733ri_lle
rimple103814583rimple
ripple103413913ripple
role45851823__role
rule49938423__rule
scarce104013633scarc_e
sice65545593si_c_e
sickle124418323sickle
sidle65124033si_dle
silicle937753silicle
simile83115633simile
simple104315173simple
since75024173sinc_e
single74520603single
sire46150413sir__e
siree55238813sir_ee
sirree64017333sirree
sizzle14309613sizzle
socle7419573_socle
spiracle1255803spiracle
terce75721843terc_e
tercel83612993tercel
tickle124616743tickle
tierce8339843tierc_e
tiercel9316203tiercel
tile45451443ti__le
tingle74319053tingle
tinkle103714453tinkle
tipple103411913tipple
tirade7311693tirade
tire46143353tir__e
tirl45029923tir_l_
tirled74714363tir_led
tirls54519803tir_ls
title54721073ti_tle
tittle63613323tittle
trice75127493tric_e
trickle133613443trickle
trifle94012883trifle
triple84215923triple
turtle63213573turtle
uncle7317053_uncle
utricle937913utricle
viable111613773viable
vice95732853vi_c_e
vile76139803vi__le
viral86419593viral_
virgule1144283virgule
virl76224473vir_l_
virls85618603vir_ls
virtue9358673virtue
vittle94711753vittle
warble113516603warble
warsle93112923warsle
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
wince105220883winc_e
windle104617953windle
winkle133812833winkle
wintle94014603wintle
wirable121610963wirable
wire75839813wir__e
wirily123310783wirily
yince105214253yinc_e
zircon1754953zircon
zizzle13247313zizzle

Search took 6 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 Limit1127164685.67319868.9
3Display Results4684680.1563000.0
 (SQL Overall)1786914685.96929936.5
 
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.