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

110 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
hollo8482216(None) 
hallo85127551hallo
hello86522981hello
hillo84721651hillo
holla84918491holla
holloa94914821holloa
holloo94415251holloo
hollos95320631hollos
hollow124212661hollow
holly114824431holly
hullo84417451hullo
apollo837182apollo
boll65634752boll_
bollox1548742bollox
bolls75531312bolls
bolo65535952bo_lo
cello74919582cello
cholla113911022cholla
cholo105217972cho_lo
collop107312312collop
colly104926772colly
doll56632492doll_
dollop9259362dollop
dolls66126922dolls
dolly96125202dolly
fillo84319782fillo
folio83820882folio
follow124010352follow
folly115022602folly
golly95121102golly
hall75741162hall_
halloa94918122halloa
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
halls85633782halls
halo76437322h_alo
helio85321192helio
hell75637892hell_
hellos95321682hellos
hells85032042hells
helo75332852h_elo
hill76439502hill_
hilloa94713032hilloa
hillos94618892hillos
hills85431352hills
hilly114422162hilly
hobo97026082ho_bo
hold86235062ho_ld
holds94623242holds
hole77553392ho_le
holed95634132holed
holes84748652holes
holey115626902holey
holily123612952holily
holk116027942ho_lk
holks124720562holks
hollas94616902hollas
holler93520612holler
holloas103814942holloas
holloed113812752holloed
holloes103818192holloes
holloos104013582holloos
hollows134412332hollows
holm95628112ho_lm
holms105117802holms
holp95727552ho_lp
hols76946292ho_ls
holt77852582ho_lt
holts85627912holts
holy106333432ho_ly
homo96126472ho_mo
hooly115022222hooly
hotly115815482hotly
howl107625692howl_
howls116219222howls
hoyle11314412hoyle
hull75428782hull_
hulloa95011182hulloa
hulloo94511732hulloo
hullos94916292hullos
hulls84923562hulls
jello126716272jello
jolly154517512jolly
kolo87026232ko_lo
loll46128382loll_
lollop8238782lollop
lolls512121732lolls
lolly85120662lolly
moll66735702moll_
molls75129782molls
molly105222492molly
molto75619602molto
nolo46229312no_lo
oleo46630482_oleo
olio46829672_olio
olla44821172_olla
phyllo1435872phyllo
polio75722552polio
poll66332132poll_
polls74627722polls
polo66236632po_lo
roll46331652roll_
rolls55326232rolls
soldo67116562soldo
solo45538942so_lo
toll45535262toll_
tolls54728432tolls
wholly15366572wholly

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 Filter178691538000.470380193.6
2DLD Change Limit538001105.7339384.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.24928595.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.