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

408 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
fire7624559(None) 
afire86215911afire
cire65836371cire
dire56644141dire
fare76354461fare
fere76342231fere
fibre104812841fibre
fice95737111fice
fie67152441fi_e
fife106027701fife
file75446641file
fine75147951fine
fir66744891fir_
fired94829741fired
firer811229251firer
fires85740751fires
firm96026451firm
firn76927501firn
firs76637711firs
five107629741five
fore78351471fore
hire75538961hire
ire36943171_ire
lire47845291lire
mire66748221mire
sire46150411sire
tire46143351tire
wire75839811wire
acre67330772acre
afore85818602afore
aide56044992aide
air38058392air_
aired66032922aired
airer54927892airer
airn46433832airn
airs46447422airs
airt45757782airt
airy75734152airy
are37874572_are
bare65460522bare
bice86235552bice
bide76041472bide
bier65531822bier
bike106532592bike
bile66147172bile
bine66650852bine
bird76128312bird
birk106326852birk
birl65830462birl
birle75023632birle
biro66131202biro
birr66022352birr
birse74517402birse
bise66437092bise
bite66546992bite
bize155926282bize
bore66051332bore
brie65837902brie
byre95023852byre
care66968372care
cere66741472cere
cine66242942cine
cires74932912cires
cite65640342cite
core67263112core
cure66149122cure
dare55848862dare
dere56845902dere
dice75841892dice
die46759652di_e
dike95935762dike
dime76237642dime
dine55555332dine
direr64927072direr
dirge75117072dirge
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dite55547552dite
dive85634772dive
dore56353302dore
dure56341812dure
eide55832232eide
ere36352772_ere
eyre75525252eyre
face96140122face
fade85736342fade
fair76332522fair_
faired105915772faired
fairer95212062fairer
fairs85825442fairs
fairy115318282fairy
fake115534942fake
fame95639392fame
fane75343562fane
far67762602far_
farce104925322farce
fard85639062fard
fared95842342fared
farer86733142farer
fares85852872fares
farl76338552farl
farle86929242farle
farm95934532farm
faro76136922faro
fart76860562fart
fate75444282fate
fave105532962fave
faze165630042faze
fe57944742f__e
fee66862012f_ee
feirie939552feirie
feme96130542feme
fer66646122fer_
feres86038182feres
fern76129322fern
fete75734922fete
fiacre1137622fiacre
fiar76427332fiar
fiars86720832fiars
fiat76646642fiat
fib86344262fi_b
fiber104921132fiber
fibres114312122fibres
fibs96329492fibs
fices106031162fices
fiche134616742fiche
fico95824592fico
fid76847682fi_d
fidge104516052fidge
fido87726392fido
fids87034732fids
fief107331352fief
fierce11348912fierce
fiery114714792fiery
fifed125115972fifed
fifer115519972fifer
fifes114822392fifes
fig76242832fi_g
figs85332642figs
figure10258832figure
fil65447142fi_l
fila74729132fila
filed95331902filed
filer85433002filer
files85441272files
filet85540162filet
fill75540192fill
fille84327402fille
film94828172film
filo76034282filo
fils75838692fils
fin66458032fi_n
find87532602find
fined94930502fined
finer85431562finer
fines86644262fines
fink117532122fink
fino76034692fino
fins75849092fins
fiord94313342fiord
fique1739142fique
firers94922682firers
firmed125411882firmed
firmer114712442firmer
firms105217422firms
firns86018542firns
firry115713532firry
first86226122first
firth115819532firth
fisc96819752fisc
fish106926272fish
fist76248422fist
fit66365452fi_t
fits76043462fits
fiver116024942fiver
fives116027362fives
fix136236102fi_x
fixed165416952fixed
fixer154717832fixer
fixes154723592fixes
fixt1410729712fixt
fixure16256542fixure
fiz156238762fi_z
fizz157519822fizz
flare84823632flare
flee76238792flee
flier86023402flier
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
flite85424962flite
floe76129772floe
flue75329852flue
foe66350812f_oe
for66952072for_
fora75937392fora
forb97131332forb
force105324272force
ford86835492ford
fores85847102fores
forge95126942forge
fork115930942fork
form95836872form
forme105225992forme
fort76456442fort
forte86131462forte
frae75330472frae
free75940182free
frere85617722frere
fret75845042f_ret
fried95322912fried
frier85225842frier
fries85535602fries
frig85424502frig
frise85322452frise
frit77044472frit
friz166324342friz
fro65530642f_ro
froe75329992froe
frore86218802frore
fry96226502f_ry
fume96727632fume
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
furze176815812furze
fuse76429992fuse
fuze166422372fuze
fyce126316832fyce
fyke145915292fyke
gibe75927772gibe
gie47149542gi_e
gird65424992gird
girl56226552girl
girn56026862girn
giro55828632giro
girt56646422girt
gite55438612gite
give85829352give
gore55744962gore
gyre84722762gyre
hare76255732hare
here76447102here
hide85134622hide
hie67652702hi_e
hike116830392hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029672hive
ice56737242_ice
ired55131872_ired
ires45639282_ires
irk76426362_irk
jibe136323382jibe
jive146123592jive
kibe106523432kibe
kier86526802kier
kike76524782kike
kine85643422kine
kir76535672kir_
kirk76221562kirk
kirn87123432kirn
kirs85831732kirs
kite85338232kite
kore85834162kore
lice66045062lice
lie38264522li_e
lier45942462lier
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lira46928682lira
liri45128252liri
lite47054542lite
litre55421462litre
live76540992live
livre85613252livre
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759322mare
mere67244442mere
mice87442222mice
mike105535282mike
mile66352562mile
mime85736392mime
mine67256152mine
mir57046762mir_
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730362miri
mirk106729492mirk
mirs66940562mirs
miry96326742miry
mise66043572mise
mite66249402mite
mitre75522422mitre
moire71017312moire
more67154522more
mure65941332mure
nice65534712nice
nide55535782nide
nine45842172nine
nite45943582nite
nitre57519682nitre
nixe115722022nixe
ogre56320742ogre
ore36661832_ore
pare66760842pare
pere66450262pere
pice84641092pice
pie55457402pi_e
pier66035292pier
pike106335212pike
pile65649692pile
pine67755712pine
pipe86434432pipe
pirn67128372pirn
pore66451262pore
pure65543332pure
pyre94925552pyre
quire144917122quire
rare45348432rare
re26153742__re
refire95419472refire
rice64942912rice
ride55945122ride
rife74632322rife
rile45650532rile
rime65138882rime
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
sere46153472sere
shire84727132shire
sice65545592sice
side55444482side
sike87138782sike
sine46560622sine
sipe67341042sipe
sir35746672sir_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sirs44338332sirs
site47052412site
size135630962size
sore47059532sore
spire75828692spire
sure45447412sure
tare45957622tare
tide55237372tide
tie36557532ti_e
tier44936142tier
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tired65228902tired
tires55437492tires
tirl45029922tirl
tiro46832362tiro
titre54619392titre
tore47359322tore
tyre75428252tyre
vibe95124492vibe
vice95732852vice
vide85432752vide
vie65447632vi_e
vier75428152vier
vile76139802vile
vine75643682vine
vireo84816452vireo
vires84529682vires
virl76224472virl
vise75632672vise
vive105426622vive
ware76254722ware
were76238332were
wide85235402wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wiry
wise75737342wise
wite75443272wite
wive105931752wive
wore77144672wore
yare75636942yare
yipe96722172yipe
yird87018982yird
yirr76513572yirr
yore76335942yore
zaire14311992zaire
zine137036152zine

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.0762351197.4
2DLD Change Limit298724080.92332364.0
3Display Results4084080.1103709.1
 (SQL Overall)1786914081.109161128.0
 
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.