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

89 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
hoyle1131441(None) 
hole77553391ho_le
hoyles12315011hoyles
bogle85821682bogle
bole66448692bo_le
boule74828042boule
boyla102912362boyla
chyle134913482chyle
coble94823172coble
cole66956112co_le
coyly135614892coyly
dhole95215362dho_le
dole56550002do_le
doyley13487282doyley
doyly124514012doyly
hale76052832h_ale
haole84820082haole
hobble133913432hobble
hoe67562722ho__e
hoise85224772hoise
hoke115935932ho_ke
hold86235062ho_ld
holed95634132ho_led
holes84748652ho_les
holey115626902ho_ley
holk116027942ho_lk
holla84918492holla
holler93520612holler
hollo84822162hollo
holly114824432holly
holm95628102ho_lm
holp95727552ho_lp
hols76946292ho_ls
holt77852582ho_lt
holy106333432ho_ly
home98042442ho_me
homie104622522homie
hondle103914522hondle
hone77549322ho_ne
hoolie93217772hoolie
hooly115022222hooly
hope96639672ho_pe
hopple132910482hopple
horde94623052horde
horse86132652horse
hose76547242ho_se
hosel86024812hosel
hotel85520742hotel
hotly115815472hotly
house89131422house
hove107132222ho_ve
hovel115017682hovel
howe106734102ho_we
howl107625692howl_
howled134014962howled
howler123514312howler
howlet123518342howlet
howls116219222howls
hoy97447912hoy__
hoya107418372hoy_a
hoyas115016162hoyas
hoyden13328932hoyden
hoys107733932hoy_s
hyla106716512h_yla
hype125519812h_ype
hyte109018942h_yte
jole117233822jo_le
joule124918202joule
mole66251832mo_le
noble74420992noble
odyle9349592odyle
ogle56325052_ogle
ole37155212_o_le
orle45630462_orle
phyle134111152phyle
pole65951302po_le
roble75223022roble
role45851822ro_le
socle7419572socle
sole46053672so_le
style85519362style
thole85620842tho_le
toile54626492toile
tole46052902to_le
voile84719722voile
vole75236982vo_le
whole114418092who_le
wyle105519382_wyle
yodle94515042yodle

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.0931921408.6
2DLD Change Limit53800891.72031279.1
3Display Results89890.0165562.5
 (SQL Overall)178691891.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.