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 “unplait” 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
unplait94860(None) 
unplaits1044811unplaits
plait75631572__plait
unlaid7311752un_laid
unlit55025462un_l_it
unpaid939472unp_aid
unplaited1236882unplaited
unpliant1047142unpliant
unsplit956562unspl_it
uplit76020802u_pl_it
enplane939723enplane
explain1667043explain
explant16310133explant
exploit1648623exploit
gunplay1343233gunpla_y
gunplays1442713gunplays
implant11311333implant
inlaid7310143in_laid
plaid85118303__plaid
plain74823303__plain
plaint85323203__plaint
plaits83816473__plaits
plant75437113__plant
plat66048873__pla_t
replant93318533replant
spait75631603_sp_ait
splat76129343_spla_t
split75729013_spl_it
sunlit61516103sun_l_it
supplant1247823supplant
ululant747693ululant
umlaut838033u_mlaut
unai44824783un__ai_
unais53420773un__ais
unapt710421593un__apt
unblest9411813unblest
unbraid1037183unbraid
uncast84215713un_cast
unchain1238943unchain
unchair1236163unchair
unclad938913uncla_d
unclamp1344993unclamp
unclarity1445363unclarity
unclasp1135963unclasp
uncleft1257493uncleft
unclip1046993uncl_ip
undulant946823undulant
unfair936233un_fair
unfaith1345783un_faith
unfit84518563un__fit
unhair937333un_hair
unhat81119263un_ha_t
unit45140073un___it
unknit1068593un_knit
unlace82215173un_lace
unlade72714153un_lade
unlash938793un_lash
unlay84613703un_la_y
unlays93810493un_lays
unlet54133333un_l_et
unmeant9510903unmeant
unnail6410583un_nail
unpack1457833unp_ack
unpent83117373unp_ent
unpin72613243unp__in
unplaced1338613unplaced
unplaiting1345503unplaiting
unplanted1236853unplanted
unplayed1437263unplayed
unplug954413unpl_ug
unplugs1042983unplugs
unpolite1049173unpolite
unsaid7411833un_said
unseat64221023unsea_t
unsmart939603unsmart
unwit84417523un__wit
upcast102710093u_pcast
updart9310743u_pdart
upland938863u_pland
upleapt11116863u_pleapt
uplift114610653u_plift
upwaft1444943u_pwaft

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.406440125.6
2DLD Change Limit134027826.14021828.5
3Display Results82820.0165125.0
 (SQL Overall)178691826.56227231.2
 
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.