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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
nunnish103593(None) 
hunnish1336161hunnish
burnish1238622burnish
donnish11187632donnish
duncish1335792duncish
furnish1337382furnish
hennish1336862hennish
mannish121710692mannish
nannyish1443302nannyish
ninnyish1442842ninnyish
punish111411502pu_nish
punkish16257692punkish
runtish1048692runtish
sunfish1338882sunfish
tannish101610572tannish
tonnish10149092tonnish
tundish1137282tundish
unwish1239092_unwish
wennish1336242wennish
banish111416043_banish
bennis84314803bennis_
brinish1239963brinish
buckish18237883buckish
bullish12511193bullish
bundist10310193bundist
bunnies94415003bunnies
bunns74718293bunn_s_
clannish1345263clannish
cronish12310863cronish
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
cunning104214623cunning
currish1238353currish
danish101513793_danish
dronish1138913dronish
dudish1148313du_dish
dullish1148743dullish
dumpish15116113dumpish
dunness8298983dunness
dunnest83312263dunnest
dunning93514473dunning
dunnite857333dunnite
duskish1535183duskish
evanish1337653evanish
finfish16268193finfish
finish124613413_finish
funnest102912003funnest
funnier103210173funnier
funnies104113603funnies
funniest113010733funniest
funnily1336373funnily
funning113813613funning
furbish1536443furbish
garnish111610843garnish
gunnies83413123gunnies
gunning93413173gunning
huffish1935713huffish
jinnis13489053jinnis_
knish1238603__knish
longish11229093longish
lumpish14127383lumpish
lungfish1543963lungfish
lungis77113023lungis_
minish115216303_minish
minxish1936213minxish
monish114217593_monish
monkish1638243monkish
moonish123311043moonish
mudfish1646263mudfish
mulish11311903mu_lish
munis75022003mu_nis_
munnion935863munnion
nanism8311203n_anism
nannie63713223nanni_e
nannies73015203nannies
nebbish1444253nebbish
nerdish1137103nerdish
newish1237903n_ewish
ninnies73713613ninnies
noirish1037883noirish
noncash1245163noncash
nourish1039703nourish
nudism9357913nu_dism
nudist73813323nu_dist
nudnick1452863nudnick
nudnik1153313nudni_k
nudniks1262333nudniks
numbfish1842603numbfish
nuncio837973nunci_o
nuncios937113nuncios
nunlike11258073nunlike
nunnery10355303nunnery
nuns45228233nu_n_s_
outfish132210573outfish
outwish13289853outwish
panfish15229973panfish
pennis84315743pennis_
pinfish15319303pinfish
pinkish16279113pinkish
planish12412053planish
plenish1239943plenish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punjis1536693punjis_
punnier93511263punnier
punniest102511583punniest
punning103414993punning
pupfish1735533pupfish
rankish14510383rankish
roundish1246253roundish
rubbish1436303rubbish
runnier74010113runnier
runniest82911203runniest
running83514593running
ruttish1048303ruttish
stonish10410653stonish
sunnah9369353sunn_ah
sunnahs10326593sunnahs
sunnas63914563sunnas_
sunnier73412153sunnier
sunniest82712913sunniest
sunnily1037833sunnily
sunning83715673sunning
sunns55017353sunn_s_
sunrise7310813sunrise
sunwise1036433sunwise
swinish1347203swinish
tarnish101611873tarnish
tennis64015303tennis_
tennist72813113tennist
thinnish1454873thinnish
tonish93415903_tonish
townish13167933townish
tunnies73614263tunnies
tunning83514453tunning
unais53420773_unais_
unlash938793_unlash
unmannish1443363unmannish
unmesh1145793_unmesh
unnoisy1044243unnoisy
unwise9510803_unwise
uppish1336633_uppish
vanish121513213_vanish
varnish13169533varnish
winish124212263_winish
youngish1543633youngish
zanyish2235903zanyish

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.406440125.6
2DLD Change Limit1340271496.75019855.9
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.21924752.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.