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

101 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
awols8471352(None) 
awls75926091aw_ls
awol75620671awol_
aals49941142a_als
abos67734412abo_s
acold86214932acold
acyls104211522acyls
ados57633512ado_s
aeons57624652aeons
agons66423782agons
ahold94714252ahold
aholds10469482aholds
ails45654712a_ils
aioli5318312aioli
aiolis6316842aiolis
aldols7109712aldols
alls46740922a_lls
aloes54933672aloes
als36663022a__ls
amoks11413552amoks
amole75724592amole
amoles84122192amoles
amyls104512692amyls
anils56326722anils
anoas57226492anoas
anole55330382anole
anoles64827432anoles
apods86316342apods
apos65433822apo_s
argols74514612argols
arils58732202arils
aryls87015812aryls
atoll57913922atoll
atolls65511352atolls
atoms76817562atoms
avos77227012avo_s
avows114910982avows
awes76037552aw_es
awl67635302aw_l_
awmous1157712awmous
awns75324432aw_ns
awoke124912002awoke
axels126313632axels
axils127217502axils
axons125517932axons
azole145118032azole
azoles154614612azoles
azons146518252azons
bawls105719322baw_ls
bowls106121432bowls
carols85124982carols
cols66553082_cols
cools75632632cools
cowls106922212cowls
diols65521012diols
dols56943052_dols
enols54718402enols
fools86824202fools
fowls115518892fowls
gaols66717572gaols
hols76946292_hols
howls116219222howls
idols65514132idols
jowls156214522jowls
mols65948572_mols
mools76027172mools
obols73715862obols
owls76022932ow_ls
parols84722612parols
pawls105617662paw_ls
pols66044562_pols
pools74427702pools
salols64017872salols
sols45448162_sols
swobs104910892swobs
swops105913972swops
swots85518432swots
taxols13328632taxols
tools55325242tools
twos76718022two_s
viols86118102viols
wails86631482wails
walls85529382walls
wauls86120552wauls
wawls115416472wawls
woes76440662_woes
wogs86531402_wogs
woks116224902_woks
wold85429072_wold
wolds95420182_wolds
wolf105729562_wolf
wolfs116214162_wolfs
wons74942042_wons
wools84421462wools
woos76238802_woos
wops96634152_wops
wos66953532_wo_s
wots76342892_wots
wows104633492_wows
yawls114613602yaw_ls
yowls115715432yowls

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 Filter178691538000.296603685.8
2DLD Change Limit538001011.62333148.5
3Display Results1011010.0303366.7
 (SQL Overall)1786911011.94991683.4
 
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.