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

477 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
sailors7321371(None) 
bailors93212401bailors
jailors14328741jailors
sailers73822311sailers
sailor63113741sailor_
tailors73212381tailors
bailers94221352bailers
bailor83412602bailor_
hailers104017262hailers
jailers144114042jailers
jailor13418572jailor_
mailers94420332mailers
nailers73215892nailers
pallors9314342pallors
parlors9312912parlors
railers74420662railers
sailer63526102sailer_
sailorly1143532sailorly
sails55738102sail__s
sallows103915542sallows
salols64017872sa_lols
salons63823682sa_lons
salvors103910902salvors
sapors84118812sa_pors
sartors7314952sartors
saviors1058992saviors
savors95616102sa_vors
sawlogs1135392sawlogs
seisors73212812seisors
seizors16328992seizors
silos56029422s_ilo_s
smilers94113842smilers
spinors939412spinors
suitors73012472suitors
tailers73720182tailers
tailor63412502tailor_
valors93413772va_lors
wailers103916802wailers
abhors11410623_abhors
actors81016753_actors
aiders74524633_aiders
ails45654713_ail__s
aimers84621913_aimers
aiolis6316843_aiolis
airers64922313_airers
airs46447423_ai__rs
aivers94822323_aivers
algors7312553_algors
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
aloes54933673_a_loes
arbors84717873_arbors
ardors74416863_ardors
armors85017813_armors
ashlars10297063ashlars
ashlers10319583ashlers
assailers943983assailers
azlons154110423_azlons
bailees93914383bailees
bailer85425253bailer_
baileys12388933baileys
bailies94120203bailies
bailout9414133bailout
bailouts1036613bailouts
bails75933523bail__s
baiters94619303baiters
balers85626933ba_lers
ballers94421013ballers
ballons93916953ballons
ballots94116033ballots
barlows12259973barlows
bawlers124412733bawlers
boilers93417063boilers
cablers114416713cablers
callers94221963callers
callous93516593callous
calory11312843ca_lory
calos74431903ca_lo_s
candors104216763candors
cantors94620753cantors
captors113914983captors
castors94919433castors
cavilers1348113cavilers
ceilers93912533ceilers
coilers93619903coilers
colors86622373_colors
daikers124010313daikers
daikons12186693daikons
dailies84219263dailies
daimons10249323daimons
dialers83614293dialers
dialogs938103dialogs
dolors75115313_dolors
editors839423editors
epilogs1076583epilogs
exilers14419733exilers
fablers124812613fablers
factors12912123factors
failles102914123failles
fails85631483fail__s
failure1035753failure
failures1135163failures
fairs85825443fai__rs
faitours1134253faitours
fallers103917993fallers
fallows133713973fallows
favors124211403fa_vors
filers94623723_filers
filos86125383_filo_s
gainers84214593gainers
gaiters83516533gaiters
galiots82311323galiots
gallons83015943gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galops94712613ga_lops
galore73514843ga_lore
galores82614323ga_lores
gaolers83511563gaolers
gators74115823ga_tors
hailer94720343hailer_
hails85231643hail__s
hairs86225173hai__rs
halers94926913ha_lers
halloas104318463halloas
halloes104021513halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harbors12412413harbors
harlots103413293harlots
haulers104012443haulers
haviors1347383haviors
jailer134316683jailer_
jails125422943jail__s
jalops15329593ja_lops
janitors1536853janitors
kails95525213kail__s
kaisers11369273kaisers
kilos95021473_kilo_s
labors84016403la_bors
ladlers84613563ladlers
lairs55425873lai__rs
lilos55821873_lilo_s
mahzors2135123mahzors
mailer84724183mailer_
mailes84329113mail_es
maillots1037453maillots
maills84215283mail_ls
mails76037783mail__s
maimers113813043maimers
mairs76228303mai__rs
majors154511093ma_jors
malars85020683ma_lars
mallows123714323mallows
manors84420883ma_nors
maulers94213303maulers
mayors115714193ma_yors
milers84625163_milers
milord999563_milord
milords10117843_milords
milos75428013_milo_s
minors85117093_minors
moilers93615203moilers
nailer64119363nailer_
nails55730403nail__s
oilers64721193_oilers
pails75833063pail__s
pairs75325833pai__rs
pallor8313673pallor_
parlor8312673parlor_
parlours1036153parlours
parlous9414293parlous
pastors94118993pastors
paviors1237603paviors
pawnors12297203pawnors
payors114312643pa_yors
pilots84018873_pilots
pilous84717753_pilous
priors83914483pri_ors
raiders84615143raiders
railbus934413railbus
railcars1045313railcars
railer64524933railer_
rails55937403rail__s
raisers73617393raisers
rancors9811373rancors
raptors94213353raptors
razors154711653ra_zors
retailors9285343retailors
rigors72813713_rigors
sabers85224733sa_bers
sabirs85414633sa_birs
sables85026693sabl_es
sabots8314693sa_bots
sabulous1046123sabulous
sackers133820223sackers
saddlers10289753saddlers
sadirons936023sadirons
safrols1036863safrols
saggars93610683saggars
saggers94017083saggers
sagos66123873sa_go_s
saices84221803sai_ces
saids65328853sai__ds
saigas74114293sai_gas
sail45447163sail___
sailboard1245893sailboard
sailboards1345473sailboards
sailboat1047683sailboat
sailboats1145233sailboats
sailed74327763sail_ed
sailfish1446053sailfish
sailing83927373sailing
sailings93513253sailings
sailless82410363sailless
saimins9312113saimins
sains55639973sai__ns
saints65122423sai_nts
saiyids11174893saiyids
sajous13310583sa_jous
sakers104125433sa_kers
salads75316963sa_lads
salals65120083sa_lals
salary9515213sa_lary
saleps85014903sa_leps
sales56055593sa_l_es
salinas73116093salinas
salines74029413salines
salivas10309603salivas
sallets73719653sallets
salliers83613333salliers
sallies73227813sallies
sallow94315753sallo_w
sallowy13369343sallowy
salmis8514273sa_lmis
salmons93713253salmons
salol55222143sa_lo_l
salon55228553sa_lo_n
saloon64418023sa_loon
saloons74415303saloons
saloop84212583sa_loop
saloops93510133saloops
salpas85116923sa_lpas
salps74423243sa_l_ps
sals46851673sa_l__s
salsas65316133sa_lsas
salters73622253salters
salts55431883sa_l_ts
salvers103916003salvers
salves94221763sa_lves
salvoes102811313salvoes
salvor94711093salvor_
salvos94613383sa_lvos
sambars115113843sambars
sambos104315193sambo_s
samburs11369343samburs
samlets93813553samlets
samplers12299403samplers
sanders84025943sanders
sandlots938293sandlots
sangars83116253sangars
sangers84421943sangers
sanious7514103sanious
sannops936693sannops
sansars73313913sansars
santirs7312963santirs
santols73513323santols
santoors837633santoors
santos64421833santo_s
santours837173santours
santurs7310763santurs
sapless93313443sapless
sapor75119253sa_por_
sapours93610613sapours
sappers113518893sappers
sarcous9312933sarcous
sardars83112903sardars
sargos74318273sargo_s
sarods74918573sa_rods
saros55238063sa_ro_s
sarsars73512143sarsars
sartor6313873sartor_
satori6415833sa_tori
satoris7317233sa_toris
satyrs937963sa_tyrs
saucers93712133saucers
saugers83914053saugers
sauls55128123saul__s
saults65816173saul_ts
sautoirs834923sautoirs
saveloys1444013saveloys
savers93825923sa_vers
savior9710173savior_
saviours1154273saviours
savor85417943sa_vor_
savory124310563sa_vory
savours10389333savours
savoys12427893sa_voys
sawers94620163sa_wers
sawhorse1443523sawhorse
sawlog1035793sawlo_g
sawyers13317533sawyers
saxhorn1744223saxhorn
saxhorns1843823saxhorns
sayers94221593sa_yers
scalars93711903scalars
scalers93817263scalers
scallops12297373scallops
scillas9310463scillas
scions82612233sci_ons
scissors1054323scissors
seafloors1243033seafloors
sealers74323553sealers
sectors93116433sectors
seiners74219273seiners
seisers73816393seisers
seisor63712333seisor_
seizers164112503seizers
seizor15428523seizor_
sellers73721303sellers
senhors103512123senhors
seniors73413613seniors
senors63620783s_enors
sensors73514623sensors
settlors8255003settlors
shallops13288313shallops
shallots11319493shallots
shallows14388853shallows
shaloms1288983shaloms
shiers94921753shi_ers
shikars1436183shikars
shills94519603shil_ls
shiners104015943shiners
shirrs94413173shi_rrs
shivers133714833shivers
sholoms1278013sholoms
sialids839723sialids
sialoid8310953sialoid
sials54227243sial__s
sidlers83414223sidlers
sieurs659043s_ieurs
siglos7311463siglo_s
signors83410903signors
silds65520523s_il_ds
silks94620683s_il_ks
sillers73822093sillers
sills55135983s_il_ls
silo46037913s_ilo__
siloed74615303s_iloed
silts55330823s_il_ts
silvas92912183s_ilvas
silvers104714033s_ilvers
simars84916933s_imars
sirs44338333s_i__rs
sitars65417593s_itars
sivers95324153s_ivers
sizars154812623s_izars
sizers155215813s_izers
skibobs1542983skibobs
skidoos1234463skidoos
skiers104713693ski_ers
skills104313913skil_ls
skimos12548803skimo_s
skirrs10448193ski_rrs
skivers14409693skivers
slaloms9106543slaloms
slicers94114923slicers
sliders83515223sliders
slivers104115253slivers
slobs74419873s__lobs
sloes54728873s__loes
slogs64521843s__logs
slops75026013s__lops
slots54830523s__lots
slows85323463s__lows
slurs54123373s__lurs
smiler83916683smiler_
smiles84522293smil_es
smileys12336323smileys
smiters93414363smiters
snails64816653snail__s
snarlers8298753snarlers
snipers93311763snipers
soils55327983soil__s
soilure736233soilure
soilures836493soilures
solions7513743solions
solons65120013s_olons
solos54830793s_olo_s
sopors85215193s_opors
sordors839983sordors
spails84817823spail__s
spallers102910723spallers
spicers113815553spicers
spiders103914413spiders
spielers10319643spielers
spiers84421743spi_ers
spigots1037793spigots
spikers135311993spikers
spiles84227913spil_es
spillers103311693spillers
spills84717453spil_ls
spilths12356023spilths
spinor839943spinor_
spinous9310443spinous
splore81611303s_plore
splores91910943s_plores
spoilers10238633spoilers
spoors84014023s_poors
squalors1744563squalors
stablers103611143stablers
stainers83212173stainers
stairs65416333stai__rs
staplers103111183staplers
stators73915553stators
stiflers11238823stiflers
stiles64328763stil_es
stills64118563stil_ls
stilts67915303stil_ts
stirs55921613sti__rs
stivers103613533stivers
stolons73410233stolons
stridors9367293stridors
stupors935873stupors
stylers10359343stylers
sublots92410913sublots
succors1137413succors
sudors7311093s_udors
suiters73618873suiters
suitor63311053suitor_
sutlers73116973sutlers
swails94913123swail__s
swallows14295883swallows
swillers11299103swillers
swills94213353swil_ls
tabors84517093ta_bors
tailer63823733tailer_
tailles72516463tailles
tailored936203tailored
tails55634193tail__s
talars66021683ta_lars
talers64628143ta_lers
talions7314093talions
tallols73311353tallols
tallows103313733tallows
talons64019423ta_lons
tilers63523493_tilers
toilers74116263toilers
trailers82912913trailers
traitors8310773traitors
vails85825933vail__s
vairs85019133vai__rs
valor83614893va_lor_
valours10248733va_lours
vapors113812693va_pors
veilers103911823veilers
viators102712013viators
vigors102911483_vigors
visors92912223_visors
vizors18328903_vizors
wailer93720323wailer_
wails86631483wail__s
wairs86424063wai__rs
waiters104218623waiters
waivers133410053waivers
walers94824463wa_lers
wallops123410413wallops
wallows133613533wallows
warlord1136293warlord
warlords1245303warlords

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274776.75019855.9
3Display Results4774770.1702805.9
 (SQL Overall)1786914777.07625253.1
 
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.