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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
receipts127469(None) 
receipt1159251receipt_
recepts113010261rece_pts
deceits102810882decei_ts
precepts14268882prece_pts
receipted1445332receipted
receiptor1343492receiptor
receiptors1443652receiptors
receives1339742receives
recept103319072rece_pt_
recipes113314462rec_ipes
recits83621352rec_i_ts
rescripts1374572rescripts
accepts13356353acce_pts
deceit93018213decei_t_
deceives1437903deceives
decrypts1642943decrypts
excepts1885203exce_pts
excerpts1943743excerpts
exempts1844023_exempts
incepts11238283ince_pts
nonreceipts15162413nonreceipts
percepts14247643perce_pts
precents123015033prece_nts
precept133112513prece_pt_
precipes143212213prec_ipes
preempts1444543pre_empts
prescripts1644733prescripts
racists92613323rac_ists
reaccepts1583213reaccepts
readapts1145583readapts
readopts1146483readopts
realists83014833realists
rebaits9312573rebai_ts
recants93217093rec_ants
recaps103615733rec_ap_s
recarpets1344383recarpets
recasts93413533rec_asts
recedes102816063rece_des
receipting1546753receipting
receive1239733recei_ve
received1437983received
receiver1337413receiver
receivers1436363receivers
recements13312283recements
recent83630853rece_nt_
receptor1256693rece_ptor
receptors1356913rece_ptors
recess8314263rece__ss
recesses10312323recesses
recharts1337663recharts
recheats1339193recheats
recipe103414893rec_ip_e
recit75235103rec_i_t_
recite83625113rec_i_te
recites93524583rec_ites
reclines103718543reclines
recoats92616643rec_oats
recoils93814873recoi_ls
recoins94019243recoi_ns
recopies12313723recopies
recounts1038773recounts
recoups1188843recoup_s
recreants1146623recreants
recruits1036563recruits
recuts83817373rec__uts
redips93713843re_dip_s
redipt94116743re_dipt_
reedits8511743re_edits
reemits9611303re_emits
reests64618893re_e_sts
refects124012743refe_cts
refits94017653re_fi_ts
regents83416543rege_nts
reheats104513523rehe_ats
rejects163910693reje_cts
reknits1137073rekni_ts
relents74018503rele_nts
relets64025673rele__ts
relicts94414593re_licts
relists73817053re_lists
remeets93712413reme_ets
remelts93511493reme_lts
remints95117293re_mints
remits85622943re_mi_ts
renests74014213rene_sts
repaints1038483repaints
repeats94316053repe_ats
repents93717623repe_nts
reprints1039903reprints
rerents73319423rere_nts
rescript1277423rescript_
resculpts1343283resculpts
reseats74319583rese_ats
resects94115593rese_cts
reseizes1759853reseizes
resents74221223rese_nts
resets65427613rese__ts
reships1239863reship_s
resifts10378703re_sifts
resists74414923re_sists
resits64725563re_si_ts
retests73813853rete_sts
retints74717013re_tints
retwists1135603retwists
reverts104715043reve_rts
revests104413733reve_sts
revets94022173reve__ts
revuists1135153revuists
reweighs1583203reweighs
rewets94617213rewe__ts
scripts11509373_scripts

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621127.39019778.3
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.59623524.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.