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

86 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
sandhog127545(None) 
sandhogs1365481sandhogs
bandog1038722band_og
sandbag11106242sandbag
sandbox1744802sandbox
sandhi1038192sandh_i
sandhis1139992sandhis
sanding93520602sanding
sandlot8311692sandlot
sandshoe1245072sandshoe
sundog837612sund_og
analog7159973_analog
ancho104515303_ancho_
anchor113911973_anchor
anchos114214893_anchos
andro6314163_andro_
andros7313303_andros
anyhow1544103_anyhow
bandbox1943763bandbox
banding114921413banding
bandogs1138363band_ogs
candor94516423cand_or
cantdog1134573cantdog
fandom122110893fand_om
gundog935793gund_og
handbag1495863handbag
handhold1645633handhold
handing123518893handing
hangdog1343133hangdog
landing92819323landing
lapdog1034443lapd_og
manihot121112053manihot
pandoor10358583pandoor
rancho114310853rancho_
ranchos123911393ranchos
random92513553rand_om
saddhu1133413saddh_u
saddhus1243673saddhus
sadhe94815133sa_dh_e
sadhes104715373sa_dhes
sadhu9459963sa_dh_u
sadhus10298463sa_dhus
salchow1544323salchow
sand55338473sand___
sandal73317283sand_al
sandals82715203sandals
sandbags1296373sandbags
sandbar10108193sandbar
sandbur10105353sandbur
sanddab1144923sanddab
sanded84920613sand_ed
sander74828533sand_er
sanders84025943sanders
sandfly1435643sandfly
sandier84017843sandier
sandling102214413sandling
sandlots938293sandlots
sandman10310173sandman
sandmen1039413sandmen
sandpit1049633sandpit
sands65228583sand__s
sandshoes1345213sandshoes
sandsoap1143723sandsoap
sandworm1446343sandworm
sandwort12410083sandwort
sandy94221133sand__y
sang55441233san___g
sangh95517453sangh__
sanghs105312063sangh_s
saning75127643san_ing
sannop837373san_nop
santo56227283san_to_
santol64515243san_tol
santoor737433santoor
santos64421833san_tos
sawlog1035793sa_wlog
seadog838743sead_og
sending94221373sending
senhor93010813sen_hor
shog86025143s___hog
snog55623633s_n__og
standing103413633standing
sundogs947103sund_ogs
synagog1243623synagog
tandoor8278563tandoor
warthog1444543warthog

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 Filter1786911340270.436409841.7
2DLD Change Limit134027865.98622390.1
3Display Results86860.0302866.7
 (SQL Overall)178691866.45227695.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.