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 “unscrambles” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

57 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
unscrambles176170(None) 
unscramble1652981unscramble_
unscrambled1861711unscrambled
unscrambler1761451unscrambler
unscramblers1891001unscramblers
scrambles15146382__scrambles
scrabbles15206283__scrabbles
scramble14177253__scramble_
scrambled16164813__scrambled
scrambler15165043__scrambler
scramblers16183543__scramblers
uncrumples1652083un_crumples
unsayables1543103unsaya_bles
unscrambling1951073unscrambling
brambles14308974___brambles
cascables15165774casc_a_bles
crambes1339954___cramb_es
cramboes1436544___cramboes
crumbles14329684___crumbles
desirables1344214desira_bles
ensamples1343124ens__amples
ensembles1344014ens__embles
incurables14105144incura_bles
inscribes1345204inscr_ib_es
insurable111011084insura_ble_
miserables1445614misera_bles
munchables1942784mun_cha_bles
rambles113118314____rambles
scabbles14167984__sc_abbles
scrabble14196994__scrabble_
scrabbled16154974__scrabbled
scrabbler15195204__scrabbler
scrabblers16213814__scrabblers
scrapples1534794__scrapples
scribbles15184954__scribbles
scumbles1447024__sc_umbles
shambles15159044__s_hambles
unactable13310054unacta_ble_
uncrates10314554un_cra__tes
uncrumple1542334un_crumple_
uncrumpled1742404un_crumpled
uncurable13710074uncura_ble_
undesirables1553314undesira_bles
unhirable1447644unhira_ble_
unsaddles1143414uns__addles
unsalable1148994unsala_ble_
unsampled1444444uns__ampled
unsayable1447224unsaya_ble_
unscalable1446354unscalable_
unscaled111410114unsc_a__led
unseeable1149454unseea_ble_
unshackles1941994uns_hackles
unsociable1447284unsocia_ble_
unstable10313764uns_ta_ble_
unstabler1145624uns_ta_bler
unstablest1244184uns_ta_blest
upscales12155994upsc_a__les

Search took 9 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 Filter1786911488190.1531167915.0
2DLD Change Limit148819578.59617312.6
3Display Results57570.0301900.0
 (SQL Overall)178691578.77920354.4
 
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.