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

124 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
settlor731473(None) 
settler73410651settler
settlors8255011settlors
bettor83612222bett_or
nettler7349502nettler
sector83415932sect_or
setter64023722sett_er
settle63915662settl_e
settled83210872settled
settlers8289022settlers
settles73916002settles
abettor956193abett_or
battler94113383battler
beetler938033beetler
better84723703bett_er
bettors93312473bett_ors
bottler94211883bottler
debtor938333debt_or
decolor1087033decolor
etalon648973_etalon
fetor81214533fe_t_or
fetter94120383fett_er
fettle93713123fettl_e
fettled11378933fettled
fettles103912733fettles
gentler8378953gentler
getter74117613gett_er
guttler8369163guttler
hector113312653hect_or
jettier14358693jettier
jetton1338033jett_on
keitloa1141933keitloa
kettle104311613kettl_e
kettles113411613kettles
kittler11338163kittler
lector83514983lect_or
letter63722583lett_er
littler7348553littler
mentor8414363ment_or
meteor84910073me_teor
mettle83815723mettl_e
mettled103510543mettled
mettles94115023mettles
mottler94410343mottler
nestler73510443nestler
nestor63713423nest_or
netter63722023nett_er
nettier74211813nettier
nettle64514583nettl_e
nettled8339943nettled
nettlers8307513nettlers
nettles73214083nettles
nettlier864813nettlier
nettly9459453nettl_y
petter83924773pett_er
pettier94213613pettier
pettle84116053pettl_e
pettled103611513pettled
pettles93916483pettles
petto76021043pett_o_
rattler74012743rattler
realtor73611353realtor
recolor978693recolor
rector84019753rect_or
retailor8285223retailor
sailor63113753s_ailor
santoor737433santoor
sartor6313883sart_or
seafloor1143323seafloor
sealer63928963se_aler
seater64534163seat_er
seatwork1546783seatwork
section92515663section
sectors93116453sect_ors
secular92211533secular
seisor63712343se_isor
seizor15428533se_izor
seller63824593se_ller
seltzer1635213seltzer
semilog1046003semilog
senator7313073senator
senhor93010813se_nhor
senior63214053se_nior
senor53822803se__nor
sensor63813843se_nsor
setal56430903setal__
setiform1345003setiform
seton55223543se_t_on
sett45949053sett___
settee63721023sett_ee
settees73513633settees
setters73822063setters
setting83621393setting
settling978943settling
setts55124323sett__s
setulose884843setulose
setulous846913setulous
sexto124415453sext_o_
sexton133610793sext_on
sextos134012163sext_os
shuttler1164903shuttler
sitter63323383sitt_er
squalor1644423squalor
staler64025823s_taler
stator64015483s_tator
stealer72913973stealer
stelar64013863s_telar
stellar72610423stellar
stentor739383stentor
stertor7310093stertor
stetson745783stetson
stolon64112073s_tolon
stupor836013s_tupor
stylar9358113s_tylar
styler94013303s_tyler
subtler92910843subtler
suitor63311053suit_or
sutler63718393s_utler
tattler73112213tattler
temblor1144093temblor
tetter64322453tett_er
vector113212063vect_or
vetter93417643vett_er
wetter93919443wett_er

Search took 7 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.423422437.4
2DLD Change Limit1340271246.18621666.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.65526850.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.