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

70 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
horizon195576(None) 
horizons2045461horizons
chorion12311772chori_on
chorizo2136322chorizo_
chorizos2245492chorizos
horizonal2153002horizonal
morion86217732mori_on
orison6411662_orison
boron76727143bor__on
borzoi1736623bor_zoi
chorions13310663chori_ons
cordon95017293cor_don
durion7510963duri_on
foison948933fo_ison
gonion73612833goni_on
gorgon8310243gor_gon
grison7310103_grison
haricot12311963haricot
harijan1735783harijan
harpoon1238313harpoon
helicon1237643helicon
hereon93914363her_eon
heriot9422343heri_ot
heritor10310563heritor
heron85025503her__on
hoatzin1943943hoatzin
hoiden103612333ho_iden
hordein1138753hordein
horizontal2251903horizontal
hormone12410503hor_mone
horn76735613hor___n
hornito1047073hornito_
hornitos1145393hornitos
horror988723hor_ror
logion76013723logi_on
lorgnon844423lorgnon
lotion65716523loti_on
lyricon1243713lyricon
morions94014643mori_ons
moron76925423mor__on
morrion959003morrion
motion85217553moti_on
noniron738373noniron
notion64516583noti_on
onion54320973_oni_on
origan7310693_origan
origin7311033_origin
orisons7310563_orisons
orlon5415003_or_lon
orzo134516783_or_zo_
orzos143311253_or_zos
perigon1039853perigon
phlorizin2344863phlorizin
poison8312223po_ison
portion9615493portion
potion84519573poti_on
prion75119993_pri_on
prison8514023_prison
ronion63315643roni_on
solion6616383soli_on
soliton7410233soliton
thoron94713903thor__on
torchon1237363torchon
torsion7310803torsion
trigon74513103_trigon
triton63914893_triton
turion6313163turi_on
virion9310683viri_on
warison1037083warison
whoreson1444013whoreson

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.390458182.1
2DLD Change Limit134027707.12618808.2
3Display Results70700.0302333.3
 (SQL Overall)178691707.54623680.2
 
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.