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

62 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
unplaits104481(None) 
unplait948601unplait_
plaits83816472__plaits
unplaited1236882unplaited
enplanes1039483enplanes
explains1766443explains
explants1737023explants
exploits1745973exploits
gunplays1442713gunpla_ys
implants1237883implants
plaids94312443__plaids
plains85019593__plains
plaints94012053__plaints
plait75631573__plait_
plants84921803__plants
plats75531373__pla_ts
replants102811243replants
spaits85017473_sp_aits
splats84817303_spla_ts
splits85416413_spl_its
supplants1344873supplants
umlauts943193u_mlauts
unais53420773un__ai_s
unbraids1144963unbraids
unchains1338303unchains
unchairs1345503unchairs
unclamps1443693unclamps
unclarity1445363unclarity
unclasps1244573unclasps
unclips1136433uncl_ips
unfaith1345783un_faith
unfaiths1443213un_faiths
unfits93910293un__fits
unhairs1036373un_hairs
unhats91110623un_ha_ts
units54923433un___its
unknits1135553un_knits
unlaces92513623un_laces
unlades82612833un_lades
unlaid7311753un_lai_d
unlays93810493un_la_ys
unlit55025463un_l_it_
unnails738223un_nails
unpacks1576093unp_acks
unpaid939473unp_ai_d
unpins82312383unp__ins
unplaced1338613unplaced
unplaiting1345503unplaiting
unplanted1236853unplanted
unplayed1437263unplayed
unpliant1047143unpliant
unplugs1042983unpl_ugs
unpolite1049173unpolite
unseats73012853unsea_ts
unsplit956563unspl_it_
unwits9389893un__wits
upcasts11185643u_pcasts
updarts1034203u_pdarts
uplands1036943u_plands
uplifts12424773u_plifts
uplit76020803u_pl_it_
upwafts1541943u_pwafts

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 Filter1786911461620.420425454.8
2DLD Change Limit146162626.31323152.5
3Display Results62620.0302066.7
 (SQL Overall)178691626.76326421.9
 
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.