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

142 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
hosen8562388(None) 
chosen116014131chosen
hose76547241hose_
hosed95830981hosed
hosel86024811hosel
hoser811529761hoser
hoses85443171hoses
hosey116127021hosey
boson76019732boson
bosun75113592bosun
chose105925402chose_
choses115825132choses
coden86128542coden
copen94826432copen
cosec96320182cosec
coses76949492coses
coset75748842coset
cosey106226712cosey
coven106925042coven
cozen165019702cozen
dose56442432dose_
dosed76626912dosed
doser66228562doser
doses65938502doses
doven94718552doven
doyen95014412doyen
dozen155017472dozen
eosin55220922eosin
haen76229452h_aen
hasten95718562hasten
hausen9610382hausen
haven114718532haven
hen67555272h__en
hisn79620932his_n
hoarsen10367992hoarsen
hodden113811452hodden
hoe67562722ho_e_
hoed87837982ho_ed
hoer76533982ho_er
hoes75755732ho_es
hogan97817702hogan
hoiden103612332hoiden
hoise85224772hoise_
hoised105117432hoised
hoises94823672hoises
hoke115935932hoke_
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
holden104113952holden
hole77553392hole_
holed95634132holed
holes84748652holes
holey115626902holey
holpen11299412holpen
home98042442home_
homed115425422homed
homer105828452homer
homes106938812homes
homey135924842homey
hon67759382ho__n
honan85319772honan
hone77549322hone_
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
hooey114926602hooey
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopes105835642hopes
horn76735612ho_rn
horse86132652horse_
horsed105321082horsed
horses94729342horses
horsey125115402horsey
hos68364192hos__
hosels94218602hosels
hosers95223962hosers
hoseys124614002hoseys
hosier94219612hosier
hosing103421102hosing
host77852832hos_t
hosta85917832hosta
hosted105020342hosted
hostel93914152hostel
hosts85526702hosts
hotel85520752hotel
house89131422house_
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
hove107132222hove_
hovel115017682hovel
hover115524132hover
howe106734102howe_
howes114730262howes
hoyden13328932hoyden
hymen13311042hymen
hyson1138692hyson
loden66621142loden
loosen66615962loosen
lose45144582lose_
losel54419422losel
loser54728672loser
loses56742012loses
mosey105922872mosey
nomen75621622nomen
nose46739362nose_
nosed65524552nosed
noses55435642noses
nosey85619882nosey
omen66828182_omen
open66427002_open
ose38147342_ose_
oses46641512_oses
oven76624142_oven
owsen84210192owsen
oxen116218592_oxen
pose66441732pose_
posed85828412posed
poser75128772poser
poses74642762poses
risen54621882risen
rose46148902rose_
rosed65930342rosed
roses56445772roses
roset55945242roset
rosin55325312rosin
rouen54920902rouen
roven85521972roven
rowen84921152rowen
sen36058522__sen
those85218142those_
token95419312token
whose114914532whose_
woken124614972woken
women104619252women
worsen95513872worsen
woven115215172woven

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 Limit538001421.75030742.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911421.88994595.6
 
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.