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

75 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
shmoozing244361(None) 
schmoozing2742721schmoozing
schmoosing1843142schmoosing
shooing112112912sh_oo_ing
shooling123012562sh_ooling
shooting122812862sh_ooting
snoozing18319082s_noozing
boozing194012163__boozing
choosing142010133ch_oosing
hooding123815203_h_ooding
hoofing143912553_h_oofing
hooking153716693_h_ooking
hooping133615703_h_ooping
hooting113919883_h_ooting
mooing93718373__moo_ing
mooning103415553__mooning
mooring102514443__mooring
mooting103019363__mooting
oozing163812203___oozing
schmoozier26262283schmoozier
schooling1546943schooling
scooping133610633s_cooping
scooting113012643s_cooting
scrooping1446593scrooping
shadowing1744263shadowing
shamoying1844523shamoying
shampooing1843093shampooing
shmooze21255263shmooz__e
shmoozed23254363shmooz_ed
shmoozes22254883shmooz_es
shoaling123111753sh_oaling
shocking184311543sh_ocking
shoeing113211883sh__oeing
shogging14308023sh_ogging
shootings13266063sh_ootings
shopping163611293sh_opping
shoring112820073sh__oring
shorting122514803sh_orting
shotting123012383sh_otting
shouting122711793sh_outing
shoving142910643sh__oving
showing143814663sh__owing
showring1548323sh_owring
shroffing1943313shroffing
shrouding1434753shrouding
simonizing2246153simonizing
smocking17349103s_mocking
smoking143210523s_m_oking
smooching1734883s_mooching
smooshing1534793s_mooshing
smoothing1535293s_moothing
snooding102910433s_nooding
snooking133010583s_nooking
snooling93013473s_nooling
snooping113811323s_nooping
snooting92813203s_nooting
snoozling19314343s_noozling
sooting82820963s__ooting
spoofing14228363s_poofing
spooking15269803s_pooking
spooling113212563s_pooling
spooning112811443s_pooning
spooring113111463s_pooring
stooging102810043s_tooging
stooking132711143s_tooking
stooling93113133s_tooling
stooping113012363s_tooping
summoning14115693summoning
swooning12278203s_wooning
swooping14338403s_wooping
symboling1744933symboling
unmooring1255813unmooring
vamoosing1543653vamoosing
whoofing18234833wh_oofing
whooping17286633wh_ooping

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 Filter1786911486410.423422437.4
2DLD Change Limit148641757.23620541.9
3Display Results75750.0302500.0
 (SQL Overall)178691757.68923239.8
 
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.