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

178 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
kotower143438(None) 
kotowed1533771kotowed
kotowers1534311kotowers
kowtower1842271kowtower
knower1337082k_nower
kotow12528712kotow__
kotows13446522kotow_s
kowtowed1941952kowtowed
kowtowers1942182kowtowers
tower85729202__tower
atoner64817193_atoner
avower1236823_avower
bestower13126203bestower
blower115316573_blower
booger94816553bo_oger
booker124719193bo_oker
boomer104618513bo_omer
boozer174815963bo_ozer
borrower1384833borrower
botcher143613223botcher
bother115218063bot_her
botonee9311833botonee
bottler94211883bottler
bottomer1245103bottomer
bower107328183__bower
colorer9312523colorer
cooer74831013co_o_er
cooker124722453co_oker
cooler84824713co_oler
cooper104221123co_oper
cooter85128613co_oter
coroner94218203coroner
cotter84926673cot_ter
cottier93814173cottier
cower104531773__cower
crower114117563_crower
cutover1235283cutover
doozer163910463do_ozer
doter65428623dot__er
dotier73917033dot_ier
dotter74419343dot_ter
dottier83910923dottier
dower95027703__dower
embower14267403embower
empower14217033empower
endower1138483endower
flower124815503_flower
follower14137073follower
footer94320773fo_oter
footier104115113footier
footler104011873footler
footwear14103373footwear
glower105114933_glower
goober93911743go_ober
gooier73516213go_oier
grower104614933_grower
hollower14127393hollower
honorer1039673honorer
hoofer124014953ho_ofer
hooker134820173ho_oker
hooper114518313ho_oper
hooter94123933ho_oter
hootier104915353hootier
hoover124314433ho_over
hotter94720083hot_ter
imbower14235663imbower
impower14247123impower
intoner7811673intoner
ionomer939833ionomer
jotter134315633jot_ter
ketone105014533ketone_
ketones115014503ketones
ketose105711813ketose_
ketoses114912873ketoses
kiter95523213kit__er
kittler11338163kittler
knotter11317643knot_ter
knottier12203983knottier
knowers1436353k_nowers
kookier10398283kookier
kosher134412973ko_sher
koto86323473koto___
kotos95717703koto__s
kotowing1634013kotowing
kowtow1643463kowtow__
kowtows1742763kowtow_s
kroner104612573k_roner
looker104816953lo_oker
looper83817113lo_oper
looser65219943lo_oser
looter64222323lo_oter
lotoses73713643lotoses
lotter64025603lot_ter
lower85830413__lower
monomer11311893monomer
mooner85317833mo_oner
mooter83921093mo_oter
mother113718643mot_her
mothier121910213mothier
motioner1037593motioner
motlier92010583motlier
motor75317293moto__r
motored1039933motored
mottler94410343mottler
mower104523453__mower
nonowner1145253nonowner
nooser65517823no_oser
notcher123610933notcher
noter55025643not__er
nother93815963not_her
noticer937273noticer
other84219103_ot_her
otter54423973_ot_ter
outpower1336673outpower
outtower1136193outtower
plower114315063_plower
pooler83819843po_oler
poorer82613993po_orer
popover1495843popover
pother113818853pot_her
potter83926983pot_ter
pottier93516493pottier
potzer174411213pot_zer
power105325953__power
prower114218123_prower
repower12329883repower
roofer94415283ro_ofer
roomer84718633ro_omer
rooser63921883ro_oser
rooter64926033ro_oter
rootier74915393rootier
rotifer1036993rotifer
rotor55519733roto__r
rotter64325463rot_ter
rower85430493__rower
shower124315113_shower
slower94016153_slower
sooner64220463so_oner
soother104215043soother
sootier73916613sootier
sorrower1165043sorrower
sower85229313__sower
stoker104417623_stoker
stoner65823203_stoner
stooker113811733stooker
stooper93813193stooper
stoper84320103_stoper
storer64721673_storer
stover94115643_stover
stowed105817203_stowed
tawer85223443__tawer
thrower1386993thrower
toker95924913__toker
toner55336243__toner
tooler63818613to_oler
tooter64420803to_oter
tootler73511123tootler
toper75231023__toper
toter55932133__toter
tother94117143tot_her
totter65021463tot_ter
towed95134583__towed
towel84920523__towel
towers94423673__towers
towery124012093__towery
toyer84521553__toyer
tutoyer1033793tutoyer
uptowner1342043uptowner
vetoer93410063veto_er
vocoder1334693vocoder
voter85121053vot__er
vower115220793__vower
widower1435343widower
wooer84316693wo_o_er
woofer124411363wo_ofer
wooler93615873wo_oler
zooier153411233zo_oier
zootier163611173zootier

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.406440125.6
2DLD Change Limit1340271786.53320515.4
3Display Results1781780.0602966.7
 (SQL Overall)1786911786.99925530.9
 
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.