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

152 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
mobbish163592(None) 
mobbism1535051mobbism
boobish14338942boobish
cubbish1635802cubbish
mobbing14299702mobbing
mobbishly2142692mobbishly
mobbisms1643772mobbisms
modish123813542mo_dish
monish114217602mo_nish
monkish1638242monkish
moonish123311042moonish
moorish123311782moorish
mopish134311592mo_pish
nebbish1444252nebbish
rubbish1436302rubbish
slobbish1544262slobbish
snobbish1544212snobbish
abolish12311503abolish
babyish1736513babyish
boarish123911913boarish
bobbies103714563bobbies
bobbin93410733bobbi_n
bobbing113113193bobbing
bobbins103410343bobbins
boggish14238653boggish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
clubbish1743813clubbish
cobbier133410163cobbier
cobbiest14118523cobbiest
cobbs115013993cobb_s_
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
cowfish1836433cowfish
coyish143710393co_yish
dobbies124113063dobbies
dobbin11339523dobbi_n
dobbins12379533dobbins
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
fobbing153410273fobbing
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
furbish1536443furbish
goatish1139563goatish
gobbing132910703gobbing
goodish1237963goodish
goyish13379013go_yish
hobbies143813343hobbies
hobbing152811123hobbing
hobbit132810543hobbi_t
hobbits14317553hobbits
hobbyist1843473hobbyist
hoboism1446623hoboism
hogfish17257023hogfish
hoggish15247593hoggish
hottish13117903hottish
jobbing19279013jobbing
kibbis14398473kibbis_
lobbied12337173lobbied
lobbies113612463lobbies
lobbing123110913lobbing
lobbyism1742813lobbyism
lobbyist1543533lobbyist
loggish12258733loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533lo_wish
maddish14289483maddish
maidish13239553maidish
mannish121710703mannish
marish114319063m_arish
mawkish1935823mawkish
maybush1742453maybush
minish115216313m_inish
minxish1936213minxish
mobbed137112243mobb_ed
mobber123613463mobb_er
mobbers133610923mobbers
mobile103613543mo_bile
mobilise1248143mobilise
mobs85737373mo_b_s_
moist76033583mo__ist
momism93410353mo_mism
monism104016313mo_nism
monist84324983mo_nist
monkfish2044003monkfish
moonfish1675333moonfish
morbid112511463morbi_d
morris83814733morris_
mortise9713533mortise
mosh95227603mo___sh
mudfish1646263mudfish
mulish11311903m_ulish
nabobish1544103nabobish
nebbishy1841303nebbishy
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbily1436693nobbily
noirish1037883noirish
nourish1039703nourish
oafish121311733_oafish
obiism1036363_obiism
obis66226843_o_bis_
oboist8312683_oboist
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oldish10169313_oldish
owlish1238703_owlish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
publish1447913publish
rabbis102613163rabbis_
robbin103611183robbi_n
robbing123313213robbing
robbins112811063robbins
roguish1156833roguish
rompish1436693rompish
rubbishy1842153rubbishy
snobbism1443403snobbism
sobbing127612883sobbing
softish13127813softish
sottish10129443sottish
soubise9118793soubise
sourish10310693sourish
tabbis102910863tabbis_
toadish1139063toadish
tonish93415913to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish
yobbos1335963yobbos_
zombis1936283zombis_

Search took 10 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.423422437.4
2DLD Change Limit1340271528.87615099.9
3Display Results1521520.1061434.0
 (SQL Overall)1786911529.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.