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

210 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
recreating13121458(None) 
recrating121318791recr_ating
retreating111414771retreating
cocreating15310292cocreating
creating113921952__creating
decreasing1446512decreasing
precreasing1645702precreasing
pretreating1448892pretreating
procreating1647692procreating
recleaning1336752recleaning
recoating121317462rec_oating
recreation12413612recreation
recreations13412252recreations
recreative1549022recreative
recruiting1347902recruiting
redreaming1446442redreaming
reerecting1339972reerecting
regrating111316212regr_ating
regreeting1237342regreeting
regretting1237782regretting
reheating132314912re_heating
repeating122618982re_peating
rereading111212712re_reading
rerenting102617662re_renting
reseating102421532re_seating
retreading12128482retreading
secreting1279822secre_ting
uncreating13310472uncreating
accreting1446333accre_ting
acerbating1546283acerbating
aerating92821003ae_r_ating
becrusting1544603becrusting
befretting1644793befretting
berating113220763be_r_ating
bereaving1537573be_reaving
brecciating1844223brecciating
cheating144014523__cheating
cleating113518133__cleating
crating103725203__cr_ating
creaking153414123__creaking
creaming133413143__creaming
creasing113314443__creasing
creatin93618133__creatin_
creatine103417413__creatine
creatins103617513__creatins
cremating14312193__cremating
cresting114017043__cresting
deaerating12311563deaerating
deceasing1338403dec_easing
decimating1648753decimating
decorating14312073decorating
decreeing1335523decre_eing
decrypting1943213decrypting
defeating142311973de_feating
degreasing1345423degreasing
deprecating1777283deprecating
depredating1655693depredating
derating103222283de_r_ating
entreating11811553entreating
erecting112415063_e_recting
escheating1645883escheating
estreating11710363estreating
excreting1946433excre_ting
execrating2047883execr_ating
federating1548853federating
ferreting13127693ferre_ting
generating12310383generating
increasing1346323increasing
intreating11614013intreating
lacerating1349443lacerating
laureating1146393laureating
macerating1549533macerating
miscreating1648493miscreating
nucleating1346933nucleating
overeating141016533overeating
peculating1549153peculating
permeating1539923permeating
precenting151012153prec_enting
precleaning1644263precleaning
preclearing1645103preclearing
preerecting1646143preerecting
preheating16310723pre_heating
racheting1537793rache_ting
racketing1647873racke_ting
reaccenting1665013reaccenting
reaccepting1863893reaccepting
rearresting1245963rearresting
rebating112418343re__bating
rebreeding1445423rebreeding
recaning111416693rec__aning
recanting122414823rec_anting
recarpeting1674363recarpeting
recasting122414233rec_asting
receding122713763rec_e_ding
receipting1546753receipting
receiving1538993rec_eiving
recementing1645223recementing
recessing12611013rec_essing
recharting1637213recharting
rechecking2244463rechecking
rechewing1836493reche_wing
reciting113118073rec__iting
recoaling121312453rec_oaling
recounting1339193recounting
recreant10311283recrea__nt
recreate10313603recreat__e
recreated12412533recreat_ed
recreates11313363recreat_es
recreational1455173recreational
recrossing1386973recrossing
recrowning1645213recrowning
recuperating1744993recuperating
recutting1239483rec_utting
redating102620173re__dating
redefeating1645333redefeating
redirecting1545613redirecting
redrafting1545963redrafting
redrawing1437213redr_awing
redressing1247823redressing
reejecting2045813reejecting
reelecting1338783reelecting
reelevating1544963reelevating
reesting93118273re__esting
refecting152413353re_fecting
reflating132514713re_flating
reflecting1638823reflecting
refloating14198323refloating
reforesting1546193reforesting
refracting1638733refracting
reframing1538623refr_aming
refreezing2344413refreezing
refreshing1746063refreshing
refronting1437273refronting
regearing112211413re_gearing
regelating1239953regelating
regrading121210203regr_ading
regrafting1545993regrafting
regranting1238323regranting
regreening1246033regreening
regressing1248143regressing
regulating12310063regulating
rehearing132211763re_hearing
reiterating12410493reiterating
rejecting192211153re_jecting
relating92725443re__lating
releasing10411013re_leasing
relegating1239483relegating
relenting102716773re_lenting
reletting102713943re_letting
relocating13310873relocating
remating112322413re__mating
remeeting12311433re_meeting
remelting12311703re_melting
renesting102514703re_nesting
renovating1447423renovating
reoperating1449023reoperating
reorienting1246353reorienting
repealing122513543re_pealing
repenting122316553re_penting
replating122217403re_plating
repleading1436623repleading
repressing13310393repressing
reprinting131510583reprinting
reprobating1647103reprobating
requesting2046313requesting
rereadings12124543re_readings
rerepeating1447183rerepeating
rerouting10311873re_routing
rescreening1444083rescreening
resealing102115673re_sealing
resecting122816483re_secting
resenting102619293re_senting
resetting102816293re_setting
resinating11313733resinating
reslating102516993re_slating
resmelting1337263resmelting
resonating11311263resonating
respeaking1736803respeaking
respecting1549883respecting
respreading1545173respreading
restating102319413re_stating
reteaming122110443re_teaming
retearing102214253re_tearing
retesting102614603re_testing
rethreading16154283rethreading
retracing12313293retr_acing
retracting13311933retracting
retreatant1054943retreatant
retroacting1447283retroacting
revealing132611883re_vealing
reverting132315133re_verting
revesting132814123re_vesting
revetting132912633re_vetting
rewearing132310703re_wearing
reweaving16227073re_weaving
rewetting132710443re_wetting
rewriting13310413rewr_iting
rocketing1666973rocke_ting
screaking16228233_screaking
screaming14217823_screaming
secretin10108343secre_tin_
secretins11108463secre_tins
segregating1445453segregating
seriating10916403se_riating
serrating10513203se_rrating
threating131010053_threating
treating92519613__treating
ulcerating1346983ulcerating
uncrating12813183uncr_ating
venerating14410053venerating

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 Filter1786911406030.390458182.1
2DLD Change Limit1406032106.92320309.5
3Display Results2102100.1101909.1
 (SQL Overall)1786912107.42324072.6
 
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.