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

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

131 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
abut6683495(None) 
abet610547941abet
about75229081about
abuts75417071abuts
but55963021_but
ab410674762ab__
aba512850952ab_a
abaft10318062abaft
abas68642082abas
abate76627842abate
abba810522652abba
abbe87627192abbe
abbot9318452abbot
abduct11108542abduct
abed79734132abed
abets75621672abets
ablaut8313262ablaut
able66340532able
ably99725132ably
abo59045962ab_o
abort76133582abort
abos67734412abos
abri65522212abri
abrupt1039942abrupt
abs59356072ab_s
abuse77119562abuse
abuzz15517212abuzz
aby810238062ab_y
abye97921002abye
abys97221882abys
act59557842a_ct
acute74720362acute
adit56443652adit
adult63520652adult
adust64117452adust
aft66849012a_ft
ague55725922ague
airt45757782airt
ait38093902a_it
album92312652album
alit46155692alit
alt36467962a_lt
alum65227612alum
ambit94223712ambit
amu58237322amu_
amus65529612amus
ant37270792a_nt
anus47131112anus
apt57352542a_pt
aqua132813962aqua
arbute8311042arbute
art38679142a_rt
arum66129032arum
at212393402a__t
att35454652a_tt
auk76234142a_uk
aunt46553652aunt
auto47432082a_uto
babu85829232babu_
babul96317712babul
babus95620332babus
baht96740012baht
bait66556002bait
barbut104617002barbut
bast66362412bast
bat510988952_bat
batt65053872batt
baud74928422baud
bet58376672_bet
bhut95425712bhut
bit57070902_bit
bot59680402_bot
bout66353292bout
brut66537962brut
bub76343982_bub
bud67041272_bud
bug65340742_bug
bum75342692_bum
bun56348142_bun
bunt65850852_bunt
bur55744692_bur
bus56950972_bus
bust65947782_bust
bute66739672_bute
buts67247692_buts
butt65143742_butt
buy86436542_buy
caput9823982caput
cut57957662_cut
daut56443562daut
debut86024142debut
gamut8322982gamut
glut56331292glut
gout56646002gout
gut46753852_gut
habit103027022habit
habu97325482habu_
habus106317142habus
hagbut1278922hagbut
haut75949732haut
hut66457292_hut
jabot14321512jabot
jut105944012_jut
kaput11717062kaput
lout45952142lout
maut65448452maut
mut58357182_mut
nut36651962_nut
obit66837082obit
out38072152_out
phut96925972phut
pout65752552pout
put55759072_put
rabat72832222rabat
rebut75927382rebut
rout46153282rout
rut35560522_rut
sabot7931782sabot
sacbut10811942sacbut
sagbut959752sagbut
scut65835542scut
shut76137592shut
slut45040592slut
smut66629782smut
tabu66328492tabu_
tabun75914372tabun
tabus74820922tabus
taut47048962taut
tout46753822tout
tut36758092_tut
ut28647032__ut

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298721310.96630923.4
3Display Results1311310.0333969.7
 (SQL Overall)1786911311.295137985.3
 
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.