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

249 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
saree5504466(None) 
laree56036291laree
sarees65329941sarees
sarge65531131sarge
scree720031711scree
siree55238811siree
spree74830861spree
agee56241492_agee
agree65226032agree
ajee115928232_ajee
akee85936812_akee
alee46652322_alee
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
bree67241262_bree
care66968372car_e
cared86050092cared
careen84119492careen
career85822242career
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
dare55848862dar_e
dared75935012dared
darer65230792darer
dares66146702dares
dree56638322_dree
eared65139502eared
farce104925322farce
fare76354462far_e
fared95842342fared
farer86733142farer
fares85852872fares
farle86929242farle
free75940182_free
gree56641562_gree
hare76255732har_e
hared95742182hared
hareem114312062hareem
harem104924452harem
hares86255542hares
hiree85427802hiree
larees65323112larees
lares54852632lares
large65325462large
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
sabe66140572sa_be
sabed86526812sabed
saber75330242saber
sabes76437462sabes
sable74732162sable
sabre74821502sabre
sabred95916532sabred
sabres85520862sabres
sacred94917102sacred
sade55544472sa_de
sades65239892sades
sadhe94815132sadhe
sae38365182sa__e
safe75930952sa_fe
safer84721812safer
safes85226722safes
sage55044592sa_ge
sager65432052sager
sages65339062sages
saice75424052saice
sake85244962sa_ke
saker95132022saker
sakes95540752sakes
sale44959702sa_le
salep77022952salep
sales56055592sales
salve85022132salve
same65245642sa_me
samek114915272samek
sane45954342sa_ne
saned65636272saned
saner54334322saner
sanes55649072sanes
saran53730302saran
sarape84817572sarape
sard55344242sar_d
sards64736182sards
sarges75128592sarges
sargo65424412sargo
sari45444042sar_i
sarin55239252sarin
saris54544952saris
sark84938972sar_k
sarks96632462sarks
sarky125521782sarky
sarod65325872sarod
sarode75317512sarode
saros55238062saros
sarsen6314232sarsen
sate45556102sa_te
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
sauce75121652sauce
saurel6511992saurel
saute55028082saute
save75741362sa_ve
saved95127112saved
saver84831252saver
saves85838632saves
sawed95628402sawed
sawer85026212sawer
saxes125229342saxes
sayed96127142sayed
sayer84926552sayer
scarce104013632scarce
scare75334462scar_e
scared95227292scared
scarer84524612scarer
scares85033002scares
scarey115016982scarey
screed95718932screed
screen85216022screen
screes85023972screes
screw109318542screw
seared75232842seared
searer65432022searer
see35772262s__ee
sere46153472ser_e
sered65737292sered
serene63522352serene
serer55935512serer
seres55448892seres
serge64727472serge
serve85425962serve
share86437082shar_e
shared105829062shared
sharer95025482sharer
shares95236412shares
shred98125612shred
shrew119720172shrew
sire46150412sir_e
sired66134282sired
sirees64624582sirees
siren54525822siren
sires55945372sires
sirree64017342sirree
skee85431472s_kee
snare54429982snar_e
snared74824552snared
snarer64620842snarer
snares65329032snares
soared74324292soared
soarer64522242soarer
soiree62919482soiree
sore47059532sor_e
sored66141782sored
sorel56231442sorel
sorer56236592sorer
sores55454282sores
spahee11313442spahee
spare75135562spar_e
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
sparse84516342sparse
sprees85620642sprees
sprue74717632sprue
stare54440262star_e
stared75429872stared
starer64027362starer
stares66038752stares
starve94613742starve
stere55328542stere
streek104111412streek
streel64214022streel
street64125772street
strep77120852strep
strew89220662strew
sure45447412sur_e
surer54833102surer
surge65027692surge
sware85828212swar_e
sycee105018622sycee
syren85216742syren
tare45957622tar_e
tared69340052tared
tares57456562tares
targe65227092targe
tarre55825632tarre
three87526912three
tree47745812_tree
varve115716852varve
ware76254722war_e
wared96339872wared
wares88250582wares
yare75636942yar_e
yarer84321572yarer

Search took 3 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.296603685.8
2DLD Change Limit538002491.70331591.3
3Display Results2492490.0633952.4
 (SQL Overall)1786912492.06286659.1
 
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.