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 “cire” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

394 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
cire6583638(None) 
care66968371care
cere66741471cere
cine66242951cine
cires74932911cires
cite65640351cite
core67263111core
cure66149121cure
dire56644151dire
fire76245601fire
hire75538971hire
ire36943181_ire
lire47845301lire
mire66748241mire
sire46150421sire
tire46143361tire
wire75839821wire
acre67330772acre
afire86215912afire
aide56045012aide
air38058402air_
aired66032922aired
airer54927892airer
airn46433842airn
airs46447432airs
airt45757792airt
airy75734162airy
are37874572_are
bare65460522bare
bice86235572bice
bide76041512bide
bier65531842bier
bike106532612bike
bile66147192bile
bine66650872bine
bird76128332bird
birk106326872birk
birl65830482birl
birle75023632birle
biro66131222biro
birr66022372birr
birse74517402birse
bise66437112bise
bite66547012bite
bize155926302bize
bore66051332bore
brie65837902brie
byre95023852byre
cade76443922cade
cadre85419022cadre
cafe95230322cafe
cage75339062cage
caird85717232caird
cairn75717512cairn
cake105439962cake
came87648752came
cane66653122cane
cape87242782cape
car59165562car_
carb85143162carb
card710245872card
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
cark105539272cark
carl65144782carl
carle74535702carle
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carse74934332carse
cart66570342cart
carte75940422carte
carve106227752carve
case65848082case
cate66254602cate
cave95941262cave
cede74928782cede
cee55952702c_ee
cepe84926652cepe
cered85227442cered
ceres75540012ceres
cero66329452cero
cete64934782cete
chare105231982chare
chide115321022chide
chile105626892chile
chime125322592chime
chine105231722chine
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chirre114111852chirre
chiru105317152chiru
chive135117622chive
chore105126762chore
ciao64924192ciao
cider84723322cider
cig67036192ci_g
cigs75625112cigs
cimex16119132cimex
cines75239682cines
cion613330922cion
circa9311402circa
circle1039702circle
cirque1735852cirque
cirri7710722cirri
cis57748042ci_s
cist67244972cist
cited84421952cited
citer74827332citer
cites74435592cites
city95122632city
civet105828732civet
civie103716352civie
clime95720892clime
cline76428532cline
clue65324532clue
code77347742code
coir66327242coir_
coirs75221052coirs
coke107038382coke
cole66956112cole
come87547702come
cone67256962cone
cope86847382cope
cor59960942cor_
cord76740922cord
cored85044222cored
corer75538872corer
cores76361852cores
corf95941482corf
cork106635692cork
corm85735382corm
corn69945812corn
cors66656442cors
corse75036182corse
cory96941512cory
cote66648732cote
cove95837072cove
cred76530882c_red
crew96122682c_rew
crib86323582crib
cried84624292cried
crier74724462crier
cries75438402cries
crime94822692crime
cripe95521142cripe
cris66233432cris
crit65743712crit
crore74922872crore
cru57129562c_ru
cry89726242c_ry
cube85830212cube
cue57544182c_ue
cuke105824982cuke
cur56841982cur_
curb86732222curb
curd77634982curd
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curf97538782curf
curie74533042curie
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curse75829142curse
curt67051712curt
curve104920022curve
cute66440452cute
cyme119420372cyme
dare55848862dare
dere56845902dere
dice75841902dice
die46759662di_e
dike95935772dike
dime76237652dime
dine55555342dine
direr64927072direr
dirge75117072dirge
dirk96326842dirk
dirl57430032dirl
dirt55550392dirt
dite55547562dite
dive85634782dive
dore56353302dore
dure56341812dure
eide55832252eide
ere36352772_ere
eyre75525252eyre
fare76354462fare
fere76342232fere
fibre104812842fibre
fice95737122fice
fie67152452fi_e
fife106027712fife
file75446652file
fine75147962fine
fir66744902fir_
fired94829742fired
firer811229252firer
fires85740752fires
firm96026462firm
firn76927512firn
firs76637722firs
five107629752five
fore78351472fore
gibe75927792gibe
gie47149552gi_e
gird65425002gird
girl56226562girl
girn56026872girn
giro55828642giro
girt56646432girt
gite55438622gite
give85829362give
gore55744962gore
gyre84722762gyre
hare76255732hare
here76447102here
hide85134652hide
hie67652712hi_e
hike116830402hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029682hive
ice56737252_ice
icier74313752icier
ired55131872_ired
ires45639282_ires
irk76426372_irk
jibe136323402jibe
jive146123602jive
kibe106523462kibe
kier86526822kier
kike76524802kike
kine85643442kine
kir76535692kir_
kirk76221582kirk
kirn87123452kirn
kirs85831752kirs
kite85338252kite
kore85834172kore
lice66045072lice
lie38264532li_e
lier45942472lier
life75433742life
like86040852like
lime66244942lime
line46965582line
lipe66839742lipe
lira46928692lira
liri45128262liri
lite47054552lite
litre55421462litre
live76541002live
livre85613252livre
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759332mare
mere67244442mere
mice87442242mice
mike105535302mike
mile66352582mile
mime85736412mime
mine67256182mine
mir57046782mir_
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730382miri
mirk106729512mirk
mirs66940582mirs
miry96326762miry
mise66043592mise
mite66249422mite
mitre75522422mitre
moire71017322moire
more67154522more
mure65941332mure
nice65534722nice
nide55535802nide
nine45842182nine
nite45943592nite
nitre57519682nitre
nixe115722032nixe
ochre103411592ochre
ogre56320742ogre
ore36661832_ore
pare66760842pare
pere66450262pere
pice84641102pice
pie55457412pi_e
pier66035302pier
pike106335222pike
pile65649702pile
pine67755722pine
pipe86434442pipe
pirn67128382pirn
pore66451262pore
pure65543332pure
pyre94925552pyre
quire144917132quire
rare45348432rare
re26153742__re
rice64942922rice
ride55945142ride
rife74632332rife
rile45650542rile
rime65138892rime
ripe66038932ripe
rise45945242rise
rite45849462rite
rive75537732rive
scare75334462scare
score75526742score
sere46153472sere
shire84727132shire
sice65545602sice
side55444502side
sike87138792sike
sine46560632sine
sipe67341052sipe
sir35746682sir_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sirs44338342sirs
site47052422site
size135630972size
sore47059532sore
spire75828692spire
sure45447412sure
tare45957622tare
tide55237392tide
tie36557542ti_e
tier44936152tier
tike85534492tike
tile45451452tile
time66235022time
tine45855142tine
tired65228902tired
tires55437492tires
tirl45029932tirl
tiro46832372tiro
titre54619392titre
tore47359322tore
tyre75428252tyre
vibe95124512vibe
vice95732862vice
vide85432772vide
vie65447642vi_e
vier75428162vier
vile76139812vile
vine75643692vine
vireo84816452vireo
vires84529682vires
virl76224482virl
vise75632682vise
vive105426632vive
ware76254722ware
were76238332were
wide85235422wide
wife105228032wife
wile75944382wile
wine74953432wine
wipe94830292wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422842wiry
wise75737352wise
wite75443282wite
wive105931762wive
wore77144672wore
yare75636942yare
yipe96722192yipe
yird87018992yird
yirr76513582yirr
yore76335942yore
zaire14311992zaire
zine137036162zine

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298723940.78038297.4
3Display Results3943940.0934236.6
 (SQL Overall)1786913941.139156884.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.