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

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

248 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
sawlog103579(None) 
sawlogs1135391sawlogs
sailor63113752sailor
sallow94315752sallow
salol55222142sa_lol
salon55228552sa_lon
sawing104323812sawing
slog56728272s__log
aglow94711973_aglow
agog68019003_a_gog
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
aloe45540193_a_loe
along65419493_a_long
alow75328593_a_low
analog7159973analog
apolog938903apolog
aswoon947013aswoon
awing96827323_awing
awl67635303_awl__
awls75926093_awl_s
awol75620673_aw_ol
awols84713523_awols
azlon144312873_azlon
backlog1635773backlog
bailor83412603bailor
ballon84117493ballon
ballot84624093ballot
bandog1038723bandog
barlow112911423barlow
bawl95326063bawl__
bawled124415693bawled
bawler114315053bawler
bawling133813863bawling
bawls105719323bawl_s
beclog1136863beclog
blog75723823__blog
bowleg12369183bowleg
callow114714663callow
calo64936443ca_lo_
calos74431903ca_los
catalog1038003catalog
cawing124322613cawing
clog76123243__clog
colog86619933_colog
dawing114819823dawing
daylong1233973daylong
dialog837973dialog
duolog835803duolog
epilog976463epilog
fallow124713853fallow
flog85523893__flog
gallon73715813gallon
gallop93311383gallop
galop84716223ga_lop
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
harlot94422803harlot
hawing134322353hawing
isolog737403isolog
jailor13418573jailor
jalop144212603ja_lop
jawing174414963jawing
kalong1177703ka_long
lapdog1034443lapdog
lawing104625283lawing
log46252683___log
magalog1144913magalog
mallow114014743mallow
mawing124020803mawing
pallor8313673pallor
parlor8312673parlor
pawing124519553pawing
pawl95123263pawl__
pawls105617663pawl_s
pawnor11357243pawnor
prolog94212973prolog
putlog965553putlog
rawly115115833rawl_y
sable74732163sabl_e
sables85026693sables
sabot7931783sa_bot
sadly94519123sadl_y
safrol937283safrol
sag46163403sa___g
sago56332673sa_go_
sagos66123873sa_gos
sail45447163sail__
sailed74327763sailed
sailer63526103sailer
sailing83927373sailing
sailors73213723sailors
sails55738103sail_s
sajou12311693sa_jou
sal36462883sa_l__
salad65321833sa_lad
salal55425703sa_lal
sale44959703sa_l_e
salep77022953sa_lep
sales56055593sa_les
salic73424713sa_lic
sall44544683sa_l_l
sallet63734543sallet
sallows103915553sallows
sallowy13369343sallowy
sally85129713sa_lly
salmi7815863sa_lmi
salmon84614183salmon
salols64017873sa_lols
salons63823693sa_lons
saloon64418023saloon
saloop84212583saloop
salp64534093sa_l_p
salpa75018353sa_lpa
salps74423243sa_lps
sals46851673sa_l_s
salsa56718923sa_lsa
salt45758523sa_l_t
salts55431883sa_lts
salty85524383sa_lty
salve85022133sa_lve
salvo84415643sa_lvo
salvor94711093salvor
salvos94613383salvos
sambo95118013sambo_
sambos104315193sambos
samlet84126563samlet
sandhog1275453sandhog
sandlot8311693sandlot
sang55441233sa__ng
saning75127643saning
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
sapling103217863sapling
sapor75119253sa_por
sapwood1366913sapwood
sargo65424413sargo_
sargos74318273sargos
sarod65325873sa_rod
sarong73914873sarong
saros55238063sa_ros
sartor6313883sartor
satang75711563satang
sating74735453sating
saul45836523saul__
sauls55128123saul_s
sault55834963saul_t
saults65816173saults
saveloy1334663saveloy
saving104724513saving
savior9710173savior
savor85417943sa_vor
savoy114713883sa_voy
saw68255353saw___
sawed95628403saw_ed
sawer85026213saw_er
sawers94620163sawers
sawfly1535133sawfly
sawlike14138443sawlike
sawn75428163saw__n
sawney12387603sawney
saws75839483saw__s
sawyer12438043sawyer
saying104325543saying
scallop11237643scallop
seadog838743seadog
semilog1046003semilog
sewing103819623sewing
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shalom11810923shalom
shawing143514883shawing
shawl116217573shawl__
shawled1437773shawled
shawling1558223shawling
shawls125411973shawl_s
shog86025143s__hog
sholom11910113sholom
sigloi737743sigloi
siglos7311473siglos
silo46037913s_ilo_
silos56029433s_ilos
slag55934353s__lag
slalom888173slalom
slob66029423s__lob
sloe45534953s__loe
slogs64521843s__logs
slop66533873s__lop
slot46049833s__lot
slow77729493s__low
slug55124643s__lug
smog76317413s__mog
snawing113612483snawing
snog55623633s__nog
solo45538943s_olo_
solon55026133s_olon
solos54830793s_olos
sowing104222913sowing
stalag7310023stalag
stolon64112073stolon
sublot82315523sublot
sundog837613sundog
swag87526733s_w_ag
swale85221593swal_e
swales93920763swales
swallow13355753swallow
swang95519723s_wang
swig85818023s_w_ig
swing96124843s_wing
swob95218633s_w_ob
swoon85014783s_woon
swoop105213433s_woop
swop95120503s_w_op
swot75134663s_w_ot
swung95610563s_wung
tailor63412503tailor
tallol63612223tallol
tallow93714203tallow
talon55824113ta_lon
tautog765713tautog
tawing104521553tawing
unclog956603unclog
valor83614893va_lor
wallop113310293wallop
wallow123913513wallow
wawl105321943wawl__
wawled133811703wawled
wawling143810963wawling
wawls115416473wawl_s
weblog1234223weblog
wog76242733__w_og
yawing134215613yawing
yawl104918973yawl__
yawled13459983yawled
yawling14369183yawling
yawls114613603yawl_s

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162485.37620966.5
3Display Results2482480.0763263.2
 (SQL Overall)1786912485.82530676.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.