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

303 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
foetors103976(None) 
fetors91014471f_etors
foetor939561foetor_
doctors1039992doctors
factors12912122factors
fetor81214532f_etor_
flexors1734772flexors
foetus958522foet_us
footers104618332footers
foretops13137482foretops
fosters104220102fosters
motors84616602mo_tors
pretors9316802pretors
rhetors1038512rhetors
rotors64917952ro_tors
abators94413083abators
abettors1056133abettors
acetous9410363acetous
actors81016763_actors
betons84919553_betons
bettors93312473bettors
bevors111610343_bevors
boaters93419243boaters
bolters94017803bolters
boors74325013bo__ors
bostons9312903bostons
bottoms1136993bottoms
boutons9310783boutons
cantors94620753cantors
captors113914983captors
castors94919443castors
coactors1239473coactors
coaters93525793coaters
codebtors1444403codebtors
coeditors1245803coeditors
coeloms1139063coeloms
colors86622373co_lors
colters93522443colters
condors104018573condors
contort91422343contort
contorts101112643contorts
contos84923233conto_s
contours1039653contours
cooters94525723cooters
copters113621283copters
costars94218013costars
costers94128333costers
cottars94412243cottars
cotters94323443cotters
cottons9312193cottons
couters93827303couters
coveters132411083coveters
covetous1347093covetous
creators102814403creators
debtors1038533debtors
decors94017773_decors
deters74724683_deters
detours858043_detours
dieters83216433dieters
doctor938993doctor_
doers65225713doe__rs
dolors75115313do_lors
donators9310403donators
donors75115793do_nors
doors65022133do__ors
doters74423913do_ters
dotters83715973dotters
editors839423editors
effectors1755033effectors
ejectors17328663ejectors
electors103013843electors
erectors103514253erectors
evertors1138953evertors
factor11911453factor_
factory15108343factory
faitours1134263faitours
falters103916473falters
fantods11177623fantods
fantoms12189153fantoms
favors124211403f_avors
fears84829393f_e_ars
fedora1038593f_edora
fedoras1137923f_edoras
feeders113712863feeders
feelers103814743feelers
felons93615763f_elons
femora1149583f_emora
femurs1136713f_emurs
feods99516853f_e_ods
feoffors1341983feoffors
feretory1447503feretory
fervors1336233fervors
festers104121393festers
fetas85624403f_et_as
fetes85630143f_et_es
fets75345943f_et__s
fetters103517903fetters
fetus85816543f_et_us
feuars938653f_euars
fevers125414893f_evers
filters103816553filters
fitters104517753fitters
flavors1337293flavors
fleers96015793fle_ers
flexor1634503flexor_
floaters112711513floaters
floors94112353f_loors
flouters11419273flouters
fluors94311373f_luors
fluters103713683fluters
foamers123812103foamers
fodders124010753fodders
foehns12204973foe_hns
foes76543443foe___s
foetal9311883foet_al
foetid10510513foet_id
foetuses1136083foetuses
fogbows1643853fogbows
fogdogs1333263fogdogs
foggers124112013foggers
foghorn1445433foghorn
foghorns1544113foghorns
foisons1047613foisons
folders113514393folders
folios93915463folio_s
folious103710733folious
follows13409923follows
fomenters1437853fomenters
fonts86124753font__s
foods95924163fo__ods
fools86824203fo__ols
footboys1644333footboys
footer94320773footer_
footies103721543footies
footlers113910793footlers
footles103715713footles
foots85528283fo__ots
footsore1146063footsore
footwork1845813footwork
footworks1945453footworks
footworn1445163footworn
forbore12249673forbore
forcers124215713forcers
fordoes11311963fordoes
foredoes12310803foredoes
foregoers1345953foregoers
foregoes1239523foregoes
foresters12312533foresters
foretold1256493foretold
foretop12117893foreto_p
forevers1438173forevers
foreword15118953foreword
forewords16117393forewords
foreworn14108853foreworn
forgers115218183forgers
forgoers1236413forgoers
forgoes11311353forgoes
forkers144615783forkers
forlorn1096423forlorn
formers128217953formers
formols12299413formols
fortes95327183fort_es
forties104323863forties
fortis95418613fort_is
forts86034453fort__s
forworn13107783forworn
foster94322223foster_
fouettes1137883fouettes
fours85521493fo__urs
fowlers133411203fowlers
foxtrot1746303foxtrot
foxtrots1843923foxtrots
foyers125413133fo_yers
fraters103517213fraters
freers94717303fre_ers
frets85523403fret__s
fretters113410303fretters
fretwork1845683fretwork
fretworks1945103fretworks
frontons1136503frontons
fuelers103912393fuelers
functors1335743functors
furors9310953f_urors
futons93911513f_utons
gators74115833_gators
goers65520253goe__rs
goiters84014443goiters
hectors123513263hectors
hoers85724923hoe__rs
honors94816793ho_nors
hooters104520473hooters
horrors1078693horrors
jetons134512613_jetons
jolters143711993jolters
jotters143413803jotters
ketols104210763_ketols
kotos95717703ko_to_s
kotows13446523ko_tows
kowtows1742763kowtows
lectors93415763lectors
lictors93212593lictors
locators102910433locators
lofters103912903lofters
loiters74116613loiters
looters74419163looters
lotos54724633lo_to_s
lotters73921063lotters
lottos64613103lotto_s
meeters94714543meeters
mentors9314993mentors
meteors94610013_meteors
meters85625833_meters
metols84115773_metols
metros84217803_metros
molters93816973molters
monitors10310823monitors
moors74923143mo__ors
mooters93818623mooters
mortars93411523mortars
motor75317293mo_tor_
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
nestors73614973nestors
netops839213_netops
nostocs947553nostocs
noters64021003no_ters
oaters65029793_oaters
odors64514283_o_dors
offerors1443533offerors
orators7313823orators
ottars64112223_ottars
otters64021513_otters
ottos54714323_otto_s
outers64230173_outers
oxters134813273_oxters
pastors94119003pastors
peters86624593_peters
plexors1645423plexors
poetess938933poetess
poetics11312073poetics
poetry1139383poet_ry
poets76024443poet__s
pontons93315553pontons
porters93722703porters
posters93928013posters
postops11311713postops
potters94024343potters
pottos84615873potto_s
pouters94221873pouters
powters124015663powters
praetors1039833praetors
pretor8315743pretor_
proctors12311513proctors
questors17147013questors
raptors94213353raptors
rectors93520513rectors
retore67630763_retore
retorn610923423_retorn
retort66831143_retort
retorts76016513_retorts
retros63820193_retros
rhetor938063rhetor_
rooters74522933rooters
rosters73727543rosters
rotators8310203rotators
rotor55519733ro_tor_
rotos56027883ro_to_s
rotters74421393rotters
routers74822873routers
sartors7314963sartors
sectors93116443sectors
senors63620783_senors
setons64620173_setons
setous64917373_setous
sopors85215203so_pors
sordors8310003sordors
sorters74221133sorters
sotols63714473so_tols
souters74422603souters
stators73915583stators
stentors839733stentors
stertors8310923stertors
suitors73012493suitors
teeters74018303teeters
tenors63217753_tenors
tooters73818773tooters
torpors939383torpors
tors46157383___tors
toters65026363to_ters
totters74618733totters
touters74018353touters
tremors93711223tremors
tutors6912333_tutors
ureters7311823ureters
vectors123212593vectors
vetoers10359473_vetoers
vetoes92914083_vetoes
viators102712023viators
victors123311183victors
voters95017443vo_ters
wontons103310533wontons
zosters163015413zosters

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.1561145455.1
2DLD Change Limit1340273036.56020430.9
3Display Results3033030.1102754.5
 (SQL Overall)1786913036.82626178.0
 
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.