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

215 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
laree5603629(None) 
larees65323111larees
lares54852631lares
large65325461large
saree55044661saree
agee56241492_agee
agree65226032agree
ajee115928232_ajee
akee85936812_akee
alee46652322_alee
allee54932122allee
are37874572_ar_e
area45843392_area
areae55229742_areae
arene55329412_arene
ares45871022_ares
arete56031352_arete
arse46539272_arse
awee76336642_awee
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bared85144482bared
barege94713542barege
barer74535802barer
bares75457132bares
barge85631022barge
bargee94624442bargee
barre75929542barre
barye105021492barye
blare75826232blar_e
blared95018242blared
blares85021632blares
bree67241262_bree
care66968372car_e
cared86050092cared
careen84119492careen
career85822242career
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
claret84026572claret
dare55848862dar_e
dared75935012dared
darer65230792darer
dares66146702dares
dree56638322_dree
eared65139502eared
farce104925322farce
fare76354462far_e
fared95842342fared
farer86733142farer
fares85852872fares
farle86929242farle
filaree10611212filaree
flare84823632flar_e
flared105317602flared
flares94521702flares
free75940182_free
glare65222962glar_e
glared84715202glared
glares75518872glares
gree56641562_gree
hare76255732har_e
hared95742182hared
hareem114312062hareem
harem104924452harem
hares86255542hares
hiree85427802hiree
label75019382label
labret8320222labret
lace66848472la_ce
laced87132642laced
lacer75833752lacer
laces76141762laces
lacey105820912lacey
lade56345982la_de
laded74232612laded
laden65022192laden
lader65633722lader
lades65141272lades
ladle66320442ladle
lager65132862lager
laired75216812laired
lake85741602la_ke
laked105731122laked
laker95432872laker
lakes95737652lakes
lame66849292la_me
lamed85235292lamed
lamer75233702lamer
lames75445542lames
lance75126722lance
lane45153332la_ne
lanes54946792lanes
lapel73716682lapel
lapse74917682lapse
lar37967532lar__
larch105919792larch
lard56742002lar_d
larded84319092larded
larder73720972larder
lards65331862lards
lardy96119272lardy
larger74417512larger
larges74824232larges
largo65319782largo
lari45839152lar_i
larine63927042larine
laris54737462laris
lark85733862lar_k
larked114519472larked
larker104519242larker
larks95227812larks
larky125218872larky
lars46956572lar_s
larum74317972larum
larva8312482larva
larvae938842larvae
lase46148512la_se
lased65132342lased
laser54633322laser
lases54944762lases
late47560482la_te
lated65240672lated
lateen64014862lateen
laten54328342laten
later54843922later
latex124717112latex
lathe85626722lathe
latke94817092latke
latte55426302latte
laurae64011662laurae
laurel649032laurel
lave75642142la_ve
laved95028592laved
laveer94110422laveer
laver85031792laver
laves86039152laves
lawed96028322lawed
laxer125420332laxer
laxes125430092laxes
layed95127382layed
layer84626472layer
laze136235052la_ze
lazed154925842lazed
lazes145129572lazes
lee36068142l__ee
levee84023812levee
lire47845292lir_e
lore45850352lor_e
lores55045402lores
lure45142462lur_e
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lycee104716742lycee
lyre75623792lyr_e
lyres85019962lyres
mare64759332mar_e
mares76457632mares
marge85328332marge
marse76231152marse
nares55544152nares
oared65030652oared
parae76335702parae
pardee93922022pardee
pare66760842par_e
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
pareve114613012pareve
parge85831852parge
parle75836162parle
parse75236992parse
parve109824852parve
payee105524722payee
pree67044732_pree
puree74632842puree
ragee65432662ragee
rakee96031172rakee
ramee74633852ramee
ranee55438102ranee
rare45348432rar_e
rared65738322rared
rarer54731702rarer
rares55247442rares
razee145827802razee
ree37974072__ree
sarees65329942sarees
sarge65531132sarge
scree720031712scree
siree55238812siree
spree74830862spree
tare45957622tar_e
tared69340052tared
tares57456562tares
targe65227092targe
tarre55825632tarre
three87526912three
tree47745812_tree
varve115716852varve
ware76254722war_e
wared96339872wared
wares88250582wares
yare75636942yar_e
yarer84321572yarer

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 Filter178691538000.313570897.8
2DLD Change Limit538002151.51335558.5
3Display Results2152150.0633412.7
 (SQL Overall)1786912151.88994595.6
 
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.