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

314 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
newish123790(None) 
delish105215612delish
fetish12310372fetish
jewfish2343542jewfish
lewis85315842lewis_
lowish12310532lowish
nebbish1444252nebbish
neigh94912382ne_igh
neist54628442ne_ist
nerdish1137102nerdish
newest9314212newest
newie81813482newi_e
newies91014072newies
news76127372new_s_
newsie9138212newsie
newsy11489392new_sy
newts86015282newts_
nowise9511072nowise
perish114619062perish
rawish123012912rawish
relish93916952relish
rewash1237672rewash
swish115114822_swish
unwish1239092unwish
wish107228732__wish
aegis6316783aegis_
aguish1059283aguish
anguish11117633anguish
anywise1345203anywise
apish105116633_apish
aspish114810333aspish
awash116613163_awash
aweigh1334933aweigh
banish111416043banish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
bekiss1236373bekiss
bemist105216953bemist
betise85616273betise
bewig1138903bewi_g
bewigs1246533bewigs
bewitch1743323bewitch
blemish1436603blemish
bluish1159243bluish
bonefish1646283bonefish
boyish142911233boyish
brewis11469983brewis_
cedis84317083cedis_
ceriph1398463ceriph
cerise84822043cerise
cherish15310463cherish
cowfish1836433cowfish
coyish143710393coyish
cuish10313173_cuish
danish101513793danish
deafish1438533deafish
deash95617243de_ash
defis96717503defis_
deism84116033de_ism
deist64633593de_ist
delis64928543delis_
delist74625053delist
demise94618323demise
dervish1436983dervish
desist74818813desist
devise104215753devise
dewier104013463dewier
dewiest11312343dewiest
dewily1338343dewily
dewing114115703dewing
dews86230603dew_s_
dish86328333__dish
dovish1338103dovish
dryish1336323dryish
dudish1148313dudish
egis56520653_egis_
elfish1267963elfish
elvish1277563elvish
encash11276943encash
endash10297123endash
endwise1136463endwise
english1137953english
enlist6417043enlist
enmesh1134893enmesh
enrich1138943enrich
entwist1048803entwist
enwind10298083enwind
ewes76328703_ewes_
exist124618943_exist
eyewash1642583eyewash
famish14311843famish
feist86230073fe_ist
fetich1479693fetich
fewest12311663fewest
finish124613413finish
fish106926273__fish
flemish1536373flemish
fluish1239333fluish
garish104516923garish
gawkish1835833gawkish
geisha1035203ge_isha
gneiss765953gne_iss
gnomish1345563gnomish
goyish13379013goyish
greyish1435173greyish
hawkish2036553hawkish
heigh124812543he_igh
heimish1535463heimish
heishi1235843he_ishi
heist87030913he_ist
hellish13310723hellish
hennish1336863hennish
hewing134514243hewing
hews105631573hew_s_
impish13499193impish
intwist1038043intwist
iwis77117013_iwis_
jadish17319903jadish
jewing174411423jewing
jews145822083jew_s_
kepis115313363kepis_
kiwis12328583kiwis_
knavish1743993knavish
knish1238603_knish
latish92416173latish
lavish124112983lavish
leash85519213le_ash
leftish13197253leftish
legist71315253legist
leis45739603le_is_
lenis56326863lenis_
levis85818553levis_
lewises1039133lewises
lexis125916033lexis_
lweis8458693lweis_
marish114319053marish
mawkish1935823mawkish
mensh105413553me_nsh
mesh96823003me__sh
metis75025903metis_
mewing123914203mewing
mewls105813233mewls_
mews96629333mew_s_
minish115216303minish
modish123813543modish
monish114217593monish
mopish134311593mopish
mulish11311903mulish
nabis76020583nabis_
nanism8311203nanism
naris55735293naris_
nazis145216083nazis_
neaps75618323neaps_
nears55529423nears_
neath86020283ne_ath
neats55931903neats_
nebbishy1841303nebbishy
nebs66124983ne_bs_
necks115119333necks_
needs65719633needs_
neems77316293neems_
neeps75617883neeps_
negs55727363ne_gs_
negus64513563negus_
neif75429493ne_i_f
neifs85613043ne_ifs
neighs10387733ne_ighs
nemas75321573nemas_
nenes55329673nenes_
neolith1068783neolith
neons55818683neons_
nerds65719253nerds_
nereis6315343nereis_
nerts55924983nerts_
ness45526563ne__ss
nest45548733ne__st
nests55728003nests_
nets45941533ne_ts_
netts55320723netts_
neuks96510863neuks_
neums75414253neums_
neves87021873neves_
nevi75116423nevi__
nevus84611393nevus_
new66237093new___
newbie11135413newbie
newbies12147423newbies
newel86114133new_el
newels93710823newels
newer85717463new_er
newly114610203new_ly
newness1035703newness
newsier10147223newsier
newsies101310383newsies
newsiest11107483newsiest
newt76933743new__t
newton936983newton
nexus124710663nexus_
nigh85220663n__igh
nisi45823243n__isi
noesis6311443noesis_
noirish1037883noirish
noise55723733n_oise
noisy86813363n_oisy
nomism103010953nomism
noris54928273noris_
nosh76223543n__osh
nourish1039703nourish
nows75738233now_s_
nowts86915863nowts_
nudism9357913nudism
nudist73813323nudist
nunnish1035933nunnish
oafish121311723oafish
oddish11107653oddish
offish15137273offish
ogrish1039263ogrish
oldish10169313oldish
outwish13289853outwish
owlish1238703owlish
palish114718273palish
parish115022353parish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
peise75825773pe_ise
penis75129323penis_
peris75537073peris_
perkish16258823perkish
pettish1238283pettish
pewit104622793pewi_t
pewits112810683pewits
pews95731533pew_s_
pish96127913__pish
plenish1239943plenish
polish114916723polish
popish133812113popish
prewash1535213prewash
punish111411503punish
radish103516913radish
rakish134313963rakish
ravish123414033ravish
reddish1238033reddish
redfish1437793redfish
rehash1237433rehash
reis45343233re_is_
relist64628413relist
remise84221953remise
remiss84216353remiss
rerise64325633rerise
resh76523453re__sh
resist64524533resist
retwist1039483retwist
revise94019743revise
reweigh1464773reweigh
rewin85623963rewi_n
rewind104715883rewind
rewins95020823rewins
rewire95421403rewire
sawfish1637683sawfish
seis45542393se_is_
seise54727853se_ise
seism75019023se_ism
selfish1388513selfish
semis74623533semis_
serfish1348973serfish
sewing103819623sewing
sews75836023sew_s_
sexism15227653sexism
sexist133013483sexist
shrewish1744733shrewish
slowish1337633slowish
sneesh945893sne_esh
squish1838573squish
swash116316753_swash
swishy15365843_swishy
swiss86712903_swiss
swith115917403_swith
tewing103914823tewing
tews76431643tew_s_
tonish93415903tonish
townish13167933townish
toyish122911123toyish
twist86820983_twist
untwist1047713untwist
unwise9510803unwise
uppish1336633uppish
vanish121513213vanish
verism113214263verism
verist93823893verist
wash106033813__wash
weakish17217173weakish
wearish132310153wearish
weigh125412513we_igh
welsh113110363we_lsh
wennish1336243wennish
wettish1335963wettish
wheyish1944063wheyish
whish144512923_whish
wich125724743__wich
widish13419363widish
winish124212263winish
wis66552333__wis_
wise75737343__wise
wisha114910853__wisha
wisp97124073__wisp
wiss75630543__wiss
wist78049293__wist
with105730473__with
yetis85418393yetis_
yews105323963yew_s_
ywis105313103_ywis_
zenith1839073zenith

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163145.25021469.7
3Display Results3143140.1402242.9
 (SQL Overall)1786913145.53032313.0
 
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.