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

78 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
allod6441838(None) 
allods73615081allods
allot54933871allot
allow85420661allow
alloy85519971alloy
abled86926832abled
acold86214932acold
aglow94711972aglow
ahold94714252ahold
ailed66240282ailed
aland65526412aland
alcid85817972alcid
aldol61212332aldol
algid75415582algid
algoid83011472algoid
algor6513052algor
alkyd13537092alkyd
all36148232all__
allay85620392allay
allee54932122allee
alley85721672alley
allied74217152allied
allodia8128792allodia
allots64019172allots
allowed111610082allowed
allows94517682allows
alloyed11158032alloyed
alloys94014562alloys
alls46740922all_s
allude73910902allude
ally76935642all_y
allyl85310542allyl
almond91410432almond
almud84012182almud
aloe45540192a_loe
aloof83521572aloof
aloud65018072aloud
alow75328592a_low
also46423442also_
alto47831262alto_
altos55822952altos
apod78123182a_pod
auld54125362aul_d
axled135315812axled
azlon144312872azlon
ballad94315322ballad
balled94926892balled
ballon84117492ballon
ballot84624092ballot
blood85319522blood
called94126732called
callow114714662callow
clod76124612_clod
fallow124713852fallow
flood95215602flood
galled84622862galled
gallon73715812gallon
gallop93311382gallop
hallo85127552hallo_
halloa94918122halloa
halloed113314912halloed
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
lalled74218752lalled
malled94626112malled
mallow114014742mallow
palled94625162palled
pallid93915282pallid
pallor8313672pallor
plod76723272_plod
sallow94315752sallow
tallol63612222tallol
tallow93714202tallow
walled104021292walled
wallop113310292wallop
wallow123913512wallow

Search took 3 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.313570897.8
2DLD Change Limit53800781.72031279.1
3Display Results78780.0136000.0
 (SQL Overall)178691782.04687336.8
 
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.