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

198 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
retreating11141477(None) 
pretreating1448891pretreating
recreating131214581recreating
retreading12128481retreading
entreating11811552entreating
estreating11710362estreating
intreating11614012intreating
recrating121318792recr_ating
redreaming1446442redreaming
reerecting1339972reerecting
regrating111316212regr_ating
regreeting1237342regreeting
regretting1237782regretting
reheating132314912re_heating
reiterating12410492reiterating
repeating122618982re_peating
rereading111212712re_reading
rerenting102617662re_renting
reseating102421532re_seating
reteaming122110442ret_eaming
retearing102214252ret_earing
retesting102614602ret_esting
rethreading16154282rethreading
retracing12313292retr_acing
retracting13311932retracting
retreatant1054942retreatant
retroacting1447282retroacting
treating92519612__treating
aerating92821003ae_r_ating
befretting1644793befretting
berating113220763be_r_ating
bereaving1537573be_reaving
betraying1537713betr_aying
cocreating15310293cocreating
creating113921953__creating
deaerating12311563deaerating
decreasing1446513decreasing
defeating142311973de_feating
degreasing1345423degreasing
deprecating1777283deprecating
depredating1655693depredating
derating103222283de_r_ating
detecting13259983det_ecting
detesting112610323det_esting
detonating1248823detonating
detracting1438713detracting
deuterating1347273deuterating
erecting112415063_e_recting
federating1548853federating
ferreting13127703ferre_ting
generating12310383generating
iterating10314253iter_ating
laureating1146393laureating
maltreating1455513maltreating
metricating1647363metricating
mistreating1449283mistreating
nitrating10312673nitr_ating
outeating10814493out_eating
outrating10916403outr_ating
outreading1239283outreading
overeating141016533overeating
overtreating1648553overtreating
patriating13510203patriating
permeating1539923permeating
precreasing1645703precreasing
preerecting1646143preerecting
preheating16310723pre_heating
pretesting131810683pret_esting
pretexting20206973pret_exting
procreating1647693procreating
rearresting1245963rearresting
rebating112418343re__bating
rebreeding1445423rebreeding
recleaning1336753recleaning
recoating121317463re_coating
recreation12413613recreation
recreations13412253recreations
recreative1549023recreative
recruiting1347903recruiting
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
rejecting192211153re_jecting
relating92725443re__lating
releasing10411013re_leasing
relegating1239483relegating
relenting102716773re_lenting
reletting102713943re_letting
relocating13310873relocating
remating112322423re__mating
remeeting12311433re_meeting
remelting12311703re_melting
renesting102514703re_nesting
renovating1447423renovating
reoperating1449023reoperating
reorienting1246353reorienting
repatriating1545453repatriating
repealing122513543re_pealing
repenting122316553re_penting
replating122217403re_plating
repleading1436623repleading
repressing13310393repressing
reprinting131510583reprinting
reprobating1647103reprobating
requesting2046313requesting
rereadings12124543re_readings
rerepeating1447183rerepeating
rerouting10311873re_routing
resealing102115673re_sealing
resecting122816483re_secting
resenting102619293re_senting
resetting102816293re_setting
resinating11313733resinating
reslating102516993re_slating
resmelting1337263resmelting
resonating11311263resonating
respeaking1736803respeaking
respecting1549883respecting
respreading1545173respreading
restating102319413re_stating
restressing1266043restressing
restricting1449303restricting
retaking133114283ret__aking
retaliating1248873retaliating
retaping113012553ret__aping
retargeting1343933retargeting
retasting102513413ret_asting
retaxing162311333ret__axing
reteaching1636023ret_eaching
retelling102112493ret_elling
retieing92913713retie__ing
retinting102215253ret_inting
retorting10613273ret_orting
retotaling1186883retotaling
retracking1738163retracking
retrain7615423retr_a_in_
retraining11310243retraining
retrains8314533retr_a_ins
retreat7317533retreat___
retreatants1152553retreatants
retreated10312623retreat_ed
retreater9310203retreat_er
retreaters1047543retreaters
retreats8311413retreat__s
retrenching1743913retrenching
retrieving1445293retrieving
retrimming1544263retrimming
retrying122410453retr__ying
retting83425883ret___ting
retwisting1445633retwisting
revealing132611883re_vealing
reverting132315133re_verting
revesting132814123re_vesting
revetting132912633re_vetting
rewearing132310703re_wearing
reweaving16227073re_weaving
rewetting132710443re_wetting
rewriting13310413rewr_iting
rotating92614553rot__ating
secreting1279823secre_ting
segregating1445453segregating
seriating10916403se_riating
serrating10513213se_rrating
streaking142010323_streaking
streaming12239653_streaming
striating10914193_striating
threating131010053_threating
titrating10310113titr_ating
treading103515333__treading
uncreating13310473uncreating
untreading1247563untreading
venerating14410053venerating

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 Filter1786911406030.436409841.7
2DLD Change Limit1406031986.08023125.5
3Display Results1981980.0932129.0
 (SQL Overall)1786911986.60927037.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.