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

82 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
uncleft125749(None) 
cleft106222852__cleft
unblest9411812unblest
uncle7317052uncle__
unclean946972unclean
unclear936572unclear
uncles8317162uncle_s
unlet54133332un_le_t
ancient9514733ancient
anklet105618733ankle_t
antileft1149993antileft
cleat76335063__cleat
clef97028183__clef_
clefs106616243__clefs
clefts114610163__clefts
clept95725773__clept
clift106422193__clift
incent83320723inc_ent
incept102712753inc_ept
incest82918743inc_est
inflect1249223inflect
inlet53732403in_le_t
left76340483___left
nucleal946693nucleal
nuclear936233nuclear
nucleate1048673nucleate
nuclei857723nucle_i
nuclein966123nuclein
nucleon945553nucleon
nucleus956573nucleus
nuncle839363nuncle__
nuncles939843nuncle_s
nutlet64220563nutle_t
oncet74626543onc_e_t
rundlet83114153rundle_t
runlet63821413run_le_t
unadept1046603unadept
unbelt83015693un_belt
unbent83216593un_bent
uncast84215713unc_ast
unclad938913uncl_ad
unclamp1344993unclamp
unclasp1135963unclasp
unclench1544143unclench
unclip1046993uncl_ip
unclips1136433unclips
uncloak1365473uncloak
unclog956603uncl_og
unclogs1036803unclogs
unclose91111643unclose
uncloud1046433uncloud
uncreate10311353uncreate
uncuff1436113unc_uff
uncuffs1543143uncuffs
uncut73219173unc__ut
undrest8313013undrest
unfelt92413463un_felt
unguent839123unguent
unkent103116053un_kent
unkept123710873un_kept
unlead73312373un_lead
unled64021073un_le_d
unless62413073un_less
unlit55025463un_l_it
unmeet83815743un_meet
unmet74426393un_me_t
unpent83117373un_pent
unplait948603unplait
unrent63219783un_rent
unrest62918853un_rest
unseat64221023un_seat
unsent63820963un_sent
unset54532433un_se_t
unshift1387413unshift
unsilent849603unsilent
unspent92610893unspent
unswept1246013unswept
unvext1658173un_vext
unwept11389813un_wept
unwet84423173un_we_t
uplift114610653u_plift
yclept1336013_yclept

Search took 7 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.1561145455.1
2DLD Change Limit134027826.39320964.6
3Display Results82820.0302733.3
 (SQL Overall)178691826.57927160.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.