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

138 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
savin8462508(None) 
mavin105722951mavin
pavin105623201pavin
ravin85624651ravin
sabin74924951sabin
sain45551291sa_in
sarin55239251sarin
sasin54626571sasin
satin55935221satin
savine94220281savine
saving104724511saving
savins93923131savins
spavin114210651spavin
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amin66042252_amin
avian84616052_avian
avid88325962_avid
avion84218342_avion
ayin76331742_ayin
basin75026922basin
cabin94820942cabin
cain65643912ca_in
cavie104621592cavie
cavil103816492cavil
caving124822612caving
covin105621122covin
daven94916472daven
davit93424592davit
fagin9216572fagin
fain75840562fa_in
flavin1239302flavin
gain56042162ga_in
gamin84423002gamin
haven114718532haven
having134220372having
isatin6412212isatin
kain85334292ka_in
lain46146282la_in
lapin75222922lapin
laving104623572laving
layin84720332layin
levin84816412levin
main65345522ma_in
matin75132852matin
maven104816892maven
mavie104722562mavie
mavins115119182mavins
mavis105622722mavis
mayvin1436522mayvin
pain65647242pa_in
patin76832852patin
pavan106518472pavan
pavid115717002pavid
paving124519742paving
pavins114919662pavins
pavis106422732pavis
rain46251732ra_in
raven84723442raven
ravine95522222ravine
raving105128852raving
ravins94622562ravins
rawin85521472rawin
sabine84020392sabine
sabins85521982sabins
sabir75917002sabir
sadi55834642sadi_
sadis64930852sadis
sahib10314762sahib
said55742112sa_id
sail45447162sa_il
saimin8313662saimin
sains55639972sa_ins
saint55147072sa_int
saki85628482saki_
sakis95323672sakis
salic73424712salic
salina64221122salina
saline65132702saline
salon55228552salon
salvia93310752salvia
salving113913152salving
saning75127642saning
sapid84720932sapid
saran53730302saran
sari45444042sari_
sarins63932622sarins
saris54544952saris
sasins64923102sasins
sati45539332sati_
sating74735452sating
satins64930482satins
satiny93817982satiny
satis55633682satis
savant9416042savant
savarin10310002savarin
save75741362sav_e
saved95127112saved
saver84831252saver
saves85838632saves
savines104417632savines
savings114412952savings
savior9710172savior
savor85417942savor
savoy114713882savoy
savvy14497502savvy
sawing104323812sawing
sawn75428162sa_wn
sayid95516722sayid
saying104325542saying
serin55434442serin
seven84118312seven
shaven124213302shaven
shavie124312422shavie
shaving143414332shaving
shin75634312s_hin
sin36265892s__in
skein94814412skein
skin85927532s_kin
slain54923572slain
slaving113514832slaving
sozin14514542sozin
spavie113611382spavie
spavins12419322spavins
spin66231302s_pin
stain55727942stain
statin63921472statin
staving113915702staving
stein54620542stein
swain84919052swain
sylvin12247302sylvin
tain45548072ta_in
takin94921302takin
vain75233002va_in
wain75840202wa_in
waving134018202waving
zayin174512042zayin

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.313570897.8
2DLD Change Limit538001381.72031279.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911382.07985950.5
 
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.