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

133 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
noise5572373(None) 
hoise85224771hoise
noised75416231noised
noises65021851noises
noisy86813361noisy
noose55624061noose
nose46739361no_se
nowise9511071nowise
poise75127891poise
anise55129702anise
arise56436432arise
bise66437102_bise
boite74426322boite
bouse75931852bouse
bowse105420632bowse
copse95623922copse
corse75036182corse
cosie74728262cosie
dose56442432do_se
douse66329722douse
dowse96020812dowse
foist85730972foist
fosse86119462fosse
frise85322452frise
genoise839422genoise
goose65925902goose
gorse65926812gorse
guise64717712guise
hoised105117432hoised
hoises94823672hoises
hoist86433212hoist
horse86132652horse
hose76547242ho_se
house89131422house
incise83515332incise
iodise74214942iodise
ionise63516942ionise
joist125125652joist
koine9516482koine
kois85129402kois_
loose56627682loose
lose45144582lo_se
louse56131012louse
lowse87219902lowse
mise66043582_mise
moire71017322moire
moist76033582moist
moose76327192moose
morse76032702morse
mouse77133002mouse
naive85116212naive
neist54628442neist
nice65534712n_ice
nicoise937922nicoise
nide55535792n_ide
nine45842172n_ine
nisei54214352n_isei
nisi45823242n_isi
nite45943582n_ite
nixe115722022n_ixe
noble74420992noble
nobs66436902nobs_
node513036882no_de
nodes64633492nodes
nodose738882nodose
nods55838222nods_
noes45845392noes_
nogs56534612nogs_
noil46133242noi_l
noils55024332noils
noily86120992noily
noir46722432noi_r
noirs55615462noirs
noisier759452noisier
noisome947972noisome
nome66038422no_me
nomes74933122nomes
nomism103010952nomism
noms65636402noms_
nonce75719822nonce
none45743172no_ne
nones55639132nones
nonuse63212252nonuse
noosed75018012noosed
nooser65517822nooser
nooses65623642nooses
nope65934192no_pe
noris54928272noris_
norite63221132norite
nos38859322no_s_
nosed65524552no_sed
noses55435642no_ses
nosey85619882no_sey
nosh76223542no_sh
nosier63716322nosier
nosy76322892no_sy
note46239962no_te
notes55034582notes
notice8313442notice
nous46136982nous_
nouses64627162nouses
novae85913122novae
novice1138432novice
nows75738232nows_
nurse54420122nurse
ose38147342_o_se
owse76321622_owse
paise75028332paise
peise75825772peise
pois66539042pois_
poised94918472poised
poiser84217242poiser
poises84226542poises
pose66441732po_se
posse74722272posse
prise74632612prise
raise54828052raise
rise45945232_rise
roose56127092roose
rose46148902ro_se
rouse56634702rouse
seise54727852seise
souse56530772souse
toile54626492toile
torse55833332torse
touse55430672touse
unwise9510802unwise
vise75632672_vise
voice104915322voice
voile84719722voile
wise75737342_wise
worse86525262worse
youse85322232youse

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.296603685.8
2DLD Change Limit538001331.51335558.5
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.84297009.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.