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

63 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
shmoozes2225488(None) 
schmoozes25214901schmoozes
shmooze21255261shmooze_
shmoozed23254361shmoozed
schmooses16275632schmooses
schmooze24255012schmooze_
schmoozed26244132schmoozed
schmoozer25224362schmoozer
schmoozers26223262schmoozers
shmoes114612102shm_o_es
snoozes16289782s_noozes
boozes174916523__boozes
chooses125717423ch_ooses
hooves124815483_h_ooves
oozes145418713___oozes
schmalzes2543163schmalzes
schmelzes2542673schmelzes
schmoes14308543schm_o_es
schmoos14347513schmoo__s
schmoose15295973schmoose_
schmoosed17294303schmoosed
schmoozier26262283schmoozier
schmooziest2751803schmooziest
schmoozy27262863schmooz_y
schnozes2244493schnozes
schnozzes2242303schnozzes
scrooges1137163scrooges
semioses10611013semioses
shakoes144510023shako_es
shmaltzes2352783shmaltzes
shmoozing2443613shmoozing
shnooks1485583shnoo_ks
shoes85429663sh__o_es
shooed103916083sh_oo_ed
shooks134515633sh_oo_ks
shooled115212663sh_ooled
shools94919013sh_oo_ls
shoos84226363sh_oo__s
shooter103013993sh_ooter
shooters112811583sh_ooters
shoots94619363sh_oo_ts
shoppes143411403sh_oppes
shores94830413sh__ores
shotes95321913sh__otes
shoves124919423sh__oves
simonies10311113simonies
simonizes2047823simonizes
simooms1135573simoo_ms
simoons937943simoo_ns
smazes174311663s_m_azes
smokes124814343s_m_okes
smooches15217263s_mooches
smooshes13206863s_mooshes
smoothes13218543s_moothes
smooths12216323s_mooths
snooze15439993s_nooze_
snoozed173410133s_noozed
snoozer16409193s_noozer
snoozers17296943s_noozers
snoozles17335563s_noozles
someones1039063someones
stooges83611483s_tooges
vamooses1345523vamooses

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 Filter1786911461620.410435831.7
2DLD Change Limit146162636.87321266.1
3Display Results63630.0302100.0
 (SQL Overall)178691637.31324434.7
 
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.