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

151 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
zillahs193538(None) 
zillah1836561zillah_
fellahs13428392fellahs
hallahs133912462hallahs
kiblahs1634152kiblahs
mollahs12328282mollahs
mullahs12388732mullahs
nullahs10316992nullahs
pillars9313492pillars
villas96117262villa_s
wallahs13409472wallahs
zills144020782zill__s
aliyahs13395323aliyahs
allays94313743_allays
almahs118611613_almahs
axillars15235993axillars
axillas14278963axilla_s
ballads104212913ballads
billers94720833billers
billets94516153billets
billies93923503billies
billons93013363billons
billows123611293billows
bills75632863bill__s
bimahs13508303bi_mahs
blahs105616513__blahs
callans94518473callans
callas84526753calla_s
cellars93713693cellars
chalahs15289883chalahs
challahs16377563challahs
collars93816573collars
cullays12347703cullays
dillies84122163dillies
dills65530973dill__s
dollars83311023dollars
fallals103310193fallals
fellah124910773fellah_
fellas95116963fella_s
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillos94415083fill_os
fills84632373fill__s
filths12389783fi_lths
fullams1236553fullams
galahs105512683_galahs
gillers84216903gillers
gillies84120963gillies
gills64728193gill__s
halalahs14367443halalahs
hallah124115403hallah_
halvahs16417533halvahs
hijrahs2043443hijrahs
hillers103718733hillers
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hill_os
hills85431353hill__s
hollas94616903holla_s
iliads7448673_iliads
ills47030423_ill__s
inlays9389873_inlays
jills125122823jill__s
keblahs1634563keblahs
kiblah1535583kiblah_
kiblas1239323kibla_s
killers114215583killers
killies113318113killies
kills94526173kill__s
lallans74113533lallans
liblabs1144123liblabs
lilacs837483li_lacs
megillahs1542233megillahs
mikvahs19162493mikvahs
millage103112753millage
millages113212903millages
milldams1344633milldams
millers93621343millers
milles84526563mill_es
millets94216843millets
mills75435053mill__s
milpas101710273milpa_s
mislays12349243mislays
mollah11319453mollah_
moolahs12347383moolahs
mullah113710733mullah_
mullas84215933mulla_s
nilgais845203nilgais
nilgaus844003nilgaus
nills54926673nill__s
nullah9388143nullah_
oilcans936813oilcans
oilways1334873oilways
ollas54218283_olla_s
pilafs113511023pi_lafs
pilaus84114133pi_laus
pilaws11399433pi_laws
pillage103412603pillage
pillages113012613pillages
pillar8314023pilla_r
pillows122610123pillows
pills74130973pill__s
quillais1745003quillais
rilles64725503rill_es
rillets74216153rillets
rills55032713rill__s
scillas9310473scilla_s
selahs9313213_selahs
sillers73822103sillers
sillies73425083sillies
sills55135993sill__s
silvans10308333silvans
silvas92912183silva_s
sirrahs10377303sirrahs
tilaks1097353ti_laks
tillage83111343tillage
tillages93011263tillages
tillers73418743tillers
tills54631713till__s
tilths9459373ti_lths
villa85321233villa__
villae95615383villa_e
village113610833village
villages123010603villages
villain1038483villain
villains1138013villains
villous102810023villous
vills86429323vill__s
villus93611223vill_us
violas93713523viola_s
wallah124011993wallah_
wallas95719393walla_s
willers103517913willers
willets104414323willets
willies103920153willies
willows13299753willows
wills84528963will__s
yills83921553yill__s
zibeths2142933zibeths
zigzags1742273zigzags
zilch19438123zi_lch_
zilches21326303zilches
zill135727613zill___
zillion16188773zillion
zillions17168073zillions
zipless18276303zipless
zirams17438643zi_rams
zorillas1745483zorilla_s

Search took 7 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.423422437.4
2DLD Change Limit1340271516.00022337.8
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.48627550.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.