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 “leghorn” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
leghorn114622(None) 
leghorns1244901leghorns
bethorn1238642bethorn
bighorn1346062bighorn
dehorn10439652de_horn
foghorn1445432foghorn
legion75712982legio_n
legwork1545662legwork
longhorn1245422longhorn
alpenhorn1452093alpenhorn
alphorn1246393alphorn
althorn1047763althorn
begroan1036103begroan
bethorns1337323bethorns
bighorns1445253bighorns
dehorns11428363de_horns
dehort104618103de_hort
ephor10310013_ephor_
ephori1139603_ephori
ephors11311403_ephors
exhort16410803_exhort
foghorns1544113foghorns
hagborn1344953hagborn
highborn1743203highborn
horn76735613___horn
inkhorn1444363inkhorn
lagoon7410483lag_oon
lanthorn1147193lanthorn
learn55322663le__arn
leathern11398913leathern
lecher113415853lecher_
lechers123313963lechers
lechery15257643lechery
lectern937033lectern
lector83514983lector_
lectors93415763lectors
legator83011133legator_
legators92811033legators
leger65721513leg_er_
legers74518313leg_ers
leggin8268593leg_gin
legions84611783legions
legman949653leg_man
legmen939343leg_men
legong836963leg_ong
legroom1076093legroom
legumin1045073legumin
legworks1645373legworks
lehr75514943le_h_r_
lehrs86111133le_h_rs
lemon75618183le_mo_n
lepton82510803lepto_n
lesion64715063lesio_n
lesson64412043lesso_n
lessor64010603lessor_
lessors73610523lessors
letdown1144263letdown
lethean1037093lethean
leukon1036143leuko_n
lighten112811523lighten
ligroin848043ligroin
logion76013723logio_n
logon615922313log_o_n
longhorns1344133longhorns
lorn46435253l___orn
lowborn1245143lowborn
lugworm1344903lugworm
luthern1037653luthern
megaron10248303megaron
nephron1246653nephron
newborn1244283newborn
plethora1344823plethora
readorn8310483readorn
reborn810016963re_born
region74614903regio_n
regrown11237363regrown
reshown13257903reshown
retorn610923433re_torn
reworn98122203re_worn
saxhorn1744223saxhorn
senhor93010813senhor_
senhora10348673senhora
senhors103512133senhors
shorn85722183__shorn
thorn85318703__thorn
tinhorn1046033tinhorn
unshorn1036943unshorn

Search took 8 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.420425454.8
2DLD Change Limit134027876.95619267.8
3Display Results87870.0302900.0
 (SQL Overall)178691877.40624127.9
 
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.