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

67 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
thrummy174217(None) 
chummy18385892ch_ummy
crummy15365892_crummy
rummy124212412__rummy
thrum104713632thru_m_
thrummed1642842thrummed
thrummer1542932thrummer
thrums11429122thru_ms
thruway1643162thruway
tummy124711992t__ummy
brumby15385953_brumby
chammy18488953ch_ammy
chromy16309903chr_omy
crumby15408113_crumby
drumly1235703_drumly
dummy134712783__dummy
frumpy16466883_frumpy
gremmy1454473_gremmy
grumpy14498153_grumpy
gummy135413653__gummy
hammy155113433_h_ammy
haulmy14455553_haulmy
humpy155115673_h_umpy
mummy114913623__mummy
plummy15375663_plummy
rammy124312493__rammy
rheumy1433353rheu_my
scummy15265223_scummy
shammy16388503sh_ammy
shimmy16306413sh_immy
shlumpy1742863shlumpy
shrimpy17415403shrimpy
shrubby1742363shrubby
slummy13325863_slummy
tammy124013223t__ammy
termly1138433ter_mly
theurgy1442733theurgy
thingummy208663thingummy
thready14435903thready
thrifty1634193thrifty
throaty13428483throaty
thrombi14134443thrombi
thru76818943thru___
thrummers1642413thrummers
thrummier1641793thrummier
thrumming1742903thrumming
thruput1243863thruput
thrush12257483thru_sh
thrust91911893thru_st
thrusts10226523thrusts
thruways1742503thruways
thumb124511283th_u_mb
thumbs13377443th_umbs
thump126211573th_u_mp
thumps13449353th_umps
thusly1235133th_usly
thymey17426313th_ymey
thymy16437923th__ymy
tommy124712233t__ommy
trampy13499253t_rampy
trimly114410893t_rimly
truly84111553t_ru_ly
trump95615123t_ru_mp
trumps104611883t_rumps
trusty94710113t_rusty
whammy19375293wh_ammy
yummy15429153__yummy

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.1401276364.3
2DLD Change Limit134027677.11018850.5
3Display Results67670.0164187.5
 (SQL Overall)178691677.26624592.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.