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

133 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
requests173574(None) 
bequests1944111bequests
request16311021request_
acquests1944642acquests
bequest1837822bequest_
frequents2144442frequents
inquests1744942inquests
quests153310352__quests
reests64618892re__ests
renests74014212re_nests
requested1935892requested
requester1855512requester
requesters1944322requesters
requestor1853022requestor
requestors1943182requestors
retests73813852re_tests
revests104413732re_vests
revuists1135152revuists
roquets16398942roque_ts
sequents1756992sequents
acquest1837173acquest_
behests1235953be_hests
bequeath2242813bequeath
bequeaths2341773bequeaths
briquets1934853brique_ts
conquests2045363conquests
coquets18399893coque_ts
croquets1955213croque_ts
degusts936063degu_sts
detests83711743de_tests
devests114410473de_vests
egests74411253_e_gests
eluents738703_eluents
frequent2046423frequent_
geests75912163ge__ests
guests74311203__guests
inquest1638603inquest_
piquets1836603pique_ts
prequels1934833preque_ls
pretests10310013pre_tests
quest144121323__quest_
racquets1944763racque_ts
reagents959623reagents
realest73322433realest_
realists83014843realists
rearrests945313rearrests
rebuses94915293rebu_ses
rebuts84015193rebu__ts
recasts93413533re_casts
recepts113010263re_cepts
recess8314263re_ces_s
recheats1339193recheats
reconquests2252003reconquests
recuses94619463recu_ses
recuts83817373recu__ts
reddest9311953reddest_
redigests1154683redigests
redness82012443rednes_s
redress82511873redres_s
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
reest54938093re__est_
refects124012743re_fects
reflects13288873reflects
reflets103513153refle_ts
reforests1245533reforests
refuels10399523refue_ls
refusers11499273refusers
refuses104918553refu_ses
regents83416543re_gents
reglets83512983regle_ts
regreets9287853regreets
regress82711453regres_s
regrets83212923regre_ts
reheats104513523re_heats
reinvests1244223reinvests
rejects163910693re_jects
relents74018503re_lents
relets64025673re_le_ts
relists73817053re_lists
relucts9369673relu_cts
remeets93712413re_meets
remelts93511493re_melts
renest64529713re_nest_
rennets75212633renne_ts
repasts93611933re_pasts
repeats94316053re_peats
repents93717623re_pents
repress92712683repres_s
repulses1038393repulses
requesting2046313requesting
requiems1943253requiems
requiescats2251233requiescats
requins16310203requ_ins
requires17168703requires
requisite1865423requisite
requisites1964503requisites
requite162012483requ_ite
requites171511763requites
rerents73319423re_rents
reseats74319583re_seats
resects94115593re_sects
resents74221223re_sents
resets65427613re_se_ts
resists74414923re_sists
resmelts1046143resmelts
respects1247703respects
rests54935873r___ests
results739833resu_lts
retest64028453re_test_
retreats8311413retreats
retwists1135603retwists
reuses66025523re_u_ses
reverts104715043re_verts
revest94623603re_vest_
revets94022173re_ve_ts
revues9813903revue__s
revuist1038473revuist_
rewets94617213re_we_ts
roques154912563roque__s
roquet154415893roque_t_
roquette1755533roquette
roquettes1855063roquettes
rousts617016723r_ou_sts
rusts55026993r__u_sts
sequels1665703seque_ls
sequent16410323sequent_
sequester1844443sequester
sequesters1943843sequesters
sequestra1852543sequestra
tempests1234443tempests
toquets16367863toque_ts

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.436409841.7
2DLD Change Limit1461621336.67321903.5
3Display Results1331330.0602216.7
 (SQL Overall)1786911337.16924925.5
 
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.