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

127 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
holloaed1215739(None) 
halloaed121510151halloaed
hilloaed12136921hilloaed
hollaed11359851holl_aed
holloed113812751hollo_ed
hollooed12146491hollooed
hollowed15157021hollowed
hulloaed12105801hulloaed
bolloxed1834472bolloxed
dolloped1234982dolloped
followed15146272followed
halloed113314912hallo_ed
hallooed12168772hallooed
hallowed15179492hallowed
helloed113512422hello_ed
hilloed113211292hillo_ed
holland11349472holl_and
hollered1237602hollered
holloa94914822holloa__
holloas103814942holloa_s
holloes103818192hollo_es
hollower14127392hollower
hulloed11369792hullo_ed
hullooed12135092hullooed
lolloped1134462lolloped
allowed111610083_allowed
alloyed11158033_alloyed
balloted1189043balloted
bellowed14158603bellowed
billowed14137063billowed
bollard103210503boll_ard
bolled94722653boll__ed
bollixed1834483bollixed
bolloxes1736833bolloxes
collaged12279973collaged
collard103712923coll_ard
collared113211143collared
collated113615063collated
colleted113011663colleted
collided12309803collided
collied103316673coll_ied
collocated1546163collocated
collogued1344073collogued
colloid10312883collo_id
colluded12296463colluded
colored10313473co_lored
dolled83518073doll__ed
dollied93811143doll_ied
fallowed15127753fallowed
fellowed15136833fellowed
folioed1138033folio_ed
follower14137073follower
galloped12107143galloped
halliard12125963halliard
halloa94918123halloa__
halloas104318463halloa_s
halloes104021523hallo_es
hallower14139813hallower
haloed104717603h_alo_ed
helled104024703hell__ed
helloes103717463hello_es
hilled104022223hill__ed
hilloa94713033hilloa__
hilloas104413553hilloa_s
hillocked1942793hillocked
hilloes103815963hillo_es
hoboed124511683ho_bo_ed
holard10410573ho_l_ard
holdover1544083holdover
holed95634133ho_l__ed
holidayed1742163holidayed
holked144913663ho_l_ked
holla84918493holl_a__
hollands12247273holl_ands
hollas94616903holl_a_s
holler93520613holl__er
hollies103420813holl_ies
hollo84822163hollo___
holloaing1385793holloaing
holloing12148823holloing
holloo94415253hollo__o
holloos104013583hollo_os
hollos95320633hollo__s
hollow124212663hollo__w
holloware1543943holloware
hollowares1643763hollowares
hollowest1544903hollowest
hollowly1743383hollowly
hollows134412333hollo_ws
honored11310123ho_nored
hooded114616743ho__oded
hoodooed1344963hoodooed
hoofed134614893ho__ofed
hooked145320553ho__oked
hooped125518183ho__oped
hooted104422663ho__oted
hooved134713123ho__oved
hoptoad1344323hoptoa_d
howled134014973howl__ed
hulled103920013hull__ed
hulloa95011183hulloa__
hulloas103911913hulloa_s
hulloes104113923hullo_es
jollied15349273joll_ied
lolled74315823loll__ed
mellowed14166923mellowed
onload7268633_onloa_d
onloaded1044743_onloaded
pillowed14156383pillowed
polkaed1435323po_lkaed
pollard103511143poll_ard
polled94022003poll__ed
pollened1157783pollened
polluted1135433polluted
rolled74220243roll__ed
rollover1144453rollover
sallowed12149033sallowed
scolloped1443653scolloped
shallowed1655083shallowed
soloed74515743so_lo_ed
tallowed12157713tallowed
tolled73819033toll__ed
volleyed1543533volleyed
walloped14146833walloped
wallowed15148163wallowed
willowed15156763willowed
yellowed15185743yellowed

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 Filter1786911461620.513348325.5
2DLD Change Limit1461621276.23623438.4
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.79526297.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.