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 “nebbish” 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
nebbish144425(None) 
nebbishy1841301nebbishy
cubbish1635802cubbish
mobbish1635922mobbish
nabobish1544102nabobish
nebbishes1642972nebbishes
nerdish1137102nerdish
newish1237902ne_wish
rubbish1436302rubbish
snobbish1544212snobbish
babyish1736513babyish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
boobish14338943boobish
clubbish1743813clubbish
deafish1438533deafish
debris93311493debris_
delish105215613de_lish
dervish1436983dervish
dweebish1742183dweebish
ebbing1137073_ebbing
ebbs82411993_ebb_s_
elfish1267963_elfish
elvish1277563_elvish
english1137953english
feeblish1644163feeblish
fetish12310373fe_tish
furbish1536443furbish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
jewfish2343543jewfish
kebbie1435813kebbi_e
kebbies1537253kebbies
kibbis14398473kibbis_
leftish13197253leftish
mobbism1535053mobbism
nabbing12299963nabbing
nabis76020583n_abis_
nabobism1444113nabobism
nebs66124983ne_b_s_
nebulise1045743nebulise
neigh94912383ne__igh
neist54628443ne__ist
neolith1068783neolith
nereis6315343nereis_
newbie11135413newbi_e
newbies12147423newbies
nibbing12339553nibbing
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbily1436693nobbily
noirish1037883noirish
nourish1039703nourish
nubbier11308133nubbier
nubbiest12117313nubbiest
nubbin10308293nubbi_n
nubbins11268023nubbins
numbfish1842603numbfish
nunnish1035933nunnish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
perish114619063pe_rish
perkish16258823perkish
pettish1238283pettish
publish1447913publish
rabbis102613163rabbis_
rebbes10313533rebbes_
reddish1238033reddish
redfish1437793redfish
relish93916953re_lish
rubbishy1842153rubbishy
selfish1388513selfish
serfish1348973serfish
slobbish1544263slobbish
snobbism1443403snobbism
tabbis102910863tabbis_
weakish17217173weakish
wearish132310153wearish
webbier1445423webbier
webbiest1535353webbiest
webbing1536123webbing
wennish1336243wennish
wettish1335963wettish

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 Limit134027866.98619185.1
3Display Results86860.0302866.7
 (SQL Overall)178691867.42224075.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.