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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
allot5493387(None) 
allod64418381allod
allots64019171allots
allow85420661allow
alloy85519971alloy
ballot84624091ballot
hallot95426781hallot
abbot9318452abbot
afloat9315152afloat
afoot8420112afoot
aglet65534142aglet
aglow94711972aglow
alant55742292alant
aldol61212332aldol
alert54740652alert
algor6513052algor
alist56136782alist
alit46155692a_lit
aliyot93611712aliyot
all36148232all__
allay85620392allay
allee54932122allee
alley85721672alley
allods73615082allods
allows94517682allows
alloys94014562alloys
alls46740922all_s
ally76935642all_y
allyl85310542allyl
almost81014432almost
aloe45540192a_loe
aloft8423432aloft
aloof83521572aloof
alow75328592a_low
also46423442also_
alt36467962a_l_t
alto47831262alto_
altos55822952altos
argot67728652argot
ascot76522512ascot
azlon144312872azlon
ballet84733972ballet
ballon84117492ballon
ballots94116032ballots
blot65842322_blot
callet84536762callet
callow114714662callow
challot123613262challot
cloot76127052cloot
clot66542422_clot
fallout10313502fallout
fallow124713852fallow
galiot72322592galiot
gallet73630852gallet
galliot82214132galliot
gallon73715812gallon
galloot82814222galloot
gallop93311382gallop
galoot72719162galoot
hallo85127552hallo_
halloa94918122halloa
halloo95118972halloo
hallos95425102hallos
halloth134111252halloth
hallow124818322hallow
harlot94422802harlot
helot85332682helot
loot46955822_loot
lot38179262__lot
maillot9312172maillot
mallet84433052mallet
mallow114014742mallow
pallet84232652pallet
pallor8313672pallor
pilot77435062pilot
plot66141232_plot
reallot7312132reallot
sallet63734542sallet
sallow94315752sallow
shallot103614132shallot
slot46049832_slot
tallit63422732tallit
tallol63612222tallol
tallow93714202tallow
wallet93327092wallet
wallop113310292wallop
wallow123913512wallow

Search took 5 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 Filter178691538000.610292936.1
2DLD Change Limit53800873.59314973.6
3Display Results87870.0631381.0
 (SQL Overall)178691874.26641887.2
 
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.