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

102 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
receipted144533(None) 
receipt1159252receipt__
receiptor1343492receiptor
receipts1274692receipt_s
received1437982recei_ved
recited104319102rec_i_ted
accepted15105383acce_pted
benempted1642763benempted
brecciated1743523brecciated
deceived1535893decei_ved
decrypted1842763decrypted
eclipsed1343473_eclipsed
excepted2055233exce_pted
excerpted2153873excerpted
exempted2044143_exempted
incepted13177773ince_pted
precented14310693prece_nted
precited133013813prec_i_ted
preempted1644683pre_empted
reaccepted1743323reaccepted
readapted1344803readapted
readopted1344913readopted
rebaited11410543rebai_ted
recanted112513513rec_anted
recapped1535943rec_apped
recarpeted1543703recarpeted
receded112713043rece__ded
receipting1546753receipting
receiptors1443653receiptors
receive1239733recei_ve_
receiver1337413recei_ver
receives1339743recei_ves
recemented1546163recemented
recenter102715443rece_nter
recept103319073rece_pt__
receptor1256693rece_ptor
recepts113010263rece_pt_s
recessed1139713rece_ssed
recharted1557563recharted
recipe103414893rec_ip_e_
recipes113314463rec_ip_es
recite83625113rec_i_te_
reciter94117263rec_i_ter
recites93524583rec_i_tes
reclined113613603recli_ned
recoated113416783rec_oated
recoiled113613213recoi_led
recoined113614423recoi_ned
recomputed1744723recomputed
recopied1339843rec_opied
recounted1238713recounted
recouped13128663recoup_ed
recoupled1496163recoupled
recrated112918603rec_rated
recreated12412533recreated
recruited1236453recruited
rectified1539243rectified
redipped1434783re_dipped
reedited10310083re_edited
reemitted1245943reemitted
reested82916233re_e_sted
refected142311663refe_cted
refitted12309413re_fitted
regelated1139723regelated
reheated122415003rehe_ated
rejected182710113reje_cted
reknitted1444023reknitted
relegated1139763relegated
relented92614943rele_nted
relisted9312623re_listed
remediated1446553remediated
remelted11310153reme_lted
reminted113615083re_minted
remitted113312073re_mitted
renested92212953rene_sted
repainted1277863repainted
repeated113117443repe_ated
repented112614983repe_nted
repeopled1444383repeopled
reprinted1289043reprinted
requited18169723requi_ted
rerented92516163rere_nted
resculpted1543223resculpted
reseated93220263rese_ated
resected112514743rese_cted
reseized1839213resei_zed
resented92716963rese_nted
reshipped1753893reshipped
resifted12310153re_sifted
resisted9312693re_sisted
resited85122423re_si_ted
respited11410813respi_ted
retested92212533rete_sted
retinted94414363re_tinted
retwisted1344893retwisted
reunited939713reuni_ted
reverted122714713reve_rted
revested122612243reve_sted
revetted122210943reve_tted
reweighed1742903reweighed
rewetted12228353rewe_tted
scripted13117553_scripted

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411027.45319943.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.96922423.3
 
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.