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

326 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
retesting10261460(None) 
detesting112610321detesting
pretesting131810681pretesting
reesting93118271re_esting
renesting102514701renesting
retasting102513411retasting
revesting132814121revesting
attesting1036382attesting
detecting13259982detecting
devesting14249902devesting
egesting1039012_egesting
obtesting1245882obtesting
pretasting13239282pretasting
pretexting20206972pretexting
protesting131910252protesting
recasting122414232recasting
recessing12611012recessing
refecting152413352refecting
reheating132314912reheating
rejecting192211152rejecting
relenting102716772relenting
reletting102713942reletting
relisting102414352relisting
remeeting12311432remeeting
remelting12311702remelting
repasting122312842repasting
repeating122618982repeating
repenting122316552repenting
requesting2046312requesting
rerenting102617662rerenting
reseating102421532reseating
resecting122816482resecting
resenting102619292resenting
resetting102816292resetting
resisting103215312resisting
resting85031182r__esting
reteaming122110442reteaming
retearing102214252retearing
retelling102112492retelling
retestify1543752retestify
retinting102215252retinting
retorting10613272retorting
retreating111414772retreating
retting83425882ret__ting
retwisting1445632retwisting
reverting132315132reverting
revetting132912632revetting
rewetting132710442rewetting
testing86021052__testing
arresting1038633arresting
beestings12335923be_estings
beeswing14255763be_eswing
begetting13186583begetting
bemisting1438073bemisting
besetting12268423besetting
besting104923923__besting
betting103921403bet__ting
breasting1239583bre_asting
breveting1536263breve_ting
brevetting1644333brevetting
celestine11147943celestine
cementing1438763cementing
contesting13312213contesting
creeshing1536243cre_eshing
cresting114017043_cresting
defeating142311973defeating
defecting162510223defecting
degusting1236163degusting
dejecting20217793dejecting
deleting103314423dele_ting
delisting112710503delisting
demasting1338453demasting
dementing13311043dementing
deserting11713143deserting
desisting112810383desisting
deterging1237853deterging
deterring1138623deterring
digesting12208673digesting
divesting14298483divesting
easting84924303_e_asting
ejecting18268163_ejecting
electing112113783_electing
erecting112415063_erecting
everting122213133_everting
exerting162211153_exerting
existing1639073_existing
feasting122011323fe_asting
fetting113517873fet__ting
foresting13311363foresting
foretasting1554423foretasting
fretting122711523fret__ting
getting93316563get__ting
greeting103112353gre_e_ting
guesting1058463_guesting
heisting123411043he_isting
infesting13109513infesting
ingesting11129623ingesting
intestine9411853intestine
investing13119393investing
jesting154317713__jesting
jetting153815343jet__ting
letting83218533let__ting
lutestring1143473lutestring
meeting103314963me_e_ting
metering112915633mete_ring
molesting1237753molesting
nesting84320443__nesting
netting84018763net__ting
outeating10814493outeating
patenting1248943patenting
petering112516813pete_ring
petting103720953pet__ting
precasting15169833precasting
precenting151012153precenting
precessing1598743precessing
predestine1349323predestine
preheating16310723preheating
prelecting15310163prelecting
prepasting15168883prepasting
presenting131013023presenting
presetting131010833presetting
pretelling1338133pretelling
pretending1438613pretending
pretreating1448893pretreating
preventing161210263preventing
priesting1239483priesting
protecting151910213protecting
questing1838273_questing
ratting83822363rat__ting
reacting113317893re_acting
rearresting1245963rearresting
rebaiting12311643rebaiting
rebating112418343re_bating
rebelling122111163rebelling
rebooting12139023rebooting
rebutting1237523rebutting
recanting122414823recanting
receding122713763rece_ding
receipting1546753receipting
receiving1538993receiving
reciting113118073re_citing
recoating121317463recoating
recrating121318793recrating
recreating131214583recreating
recusing112512883recus_ing
recutting1239483recutting
redacting13612303redacting
redating102620173re_dating
redeeming1337363redeeming
redefying1736093redefying
redenying1437783redenying
redesign1045073redes_ign
redigesting1444573redigesting
redressing1247823redressing
reeding94124133re_e_ding
reediting11310953reediting
reedling102414273re_edling
reefing114016863re_e_fing
reejecting2045813reejecting
reeking123318643re_e_king
reelecting1338783reelecting
reeling83126863re_e_ling
reerecting1339973reerecting
reeving113717663re_e_ving
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
refencing15188853refencing
referring1338033referring
refitting132811123refitting
reflating132514713reflating
reflecting1638823reflecting
reforesting1546193reforesting
refreshing1746063refreshing
refusing122310873refus_ing
refuting121911903re_futing
regearing112211413regearing
regelating1239953regelating
regrating111316213regrating
regreeting1237343regreeting
regressing1248143regressing
regretting1237783regretting
rehashing1647113rehashing
rehearing132211763rehearing
reheeling13218263reheeling
rehemming1734743rehemming
reinvesting1545323reinvesting
reissuing1034613reissuing
reiterating12410493reiterating
rekeying1637563reke_ying
relating92725443re_lating
releasing10411013releasing
relegating1239483relegating
relending112412023relending
relishing13229183relishing
relucting1239773relucting
remating112322423re_mating
remedying1635143remedying
remending132311313remending
remerging1358323remerging
reminting122315103reminting
remising112516453remis_ing
remitting122412623remitting
reneging102111533rene_ging
renewing121910713rene_wing
renting84026853r__enting
repassing12249423repassing
repealing122513543repealing
repegging1435593repegging
repelling122312753repelling
reperking1638703reperking
replating122217403replating
reporting12513903reporting
reposing111213803repos_ing
repositing13310493repositing
repotting12511123repotting
repressing13310393repressing
reputing112412603re_puting
requiting1939883requiting
rereading111212713rereading
rerising93017783reris_ing
rerouting10311873rerouting
resealing102115673resealing
reseeding112410493reseeding
reseeing92412623rese_eing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
reserving131110643reserving
resettling1135893resettling
resewing122712263rese_wing
resifting133512093resifting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resmelting1337263resmelting
resorting10614613resorting
respecting1549883respecting
respiting121912863respiting
restarting11310663restarting
restating102319413restating
restressing1266043restressing
restring91518783r__estring
resulting10311083resulting
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retaining102114733retaining
retaking133114283ret_aking
retaping113012553ret_aping
retarding111110653retarding
retaxing162311333ret_axing
retching143412173ret_ching
reteaching1636023reteaching
retellings11244653retellings
retention91611483retention
retentions101611113retentions
retentive1249853retentive
retest64028453retest___
retested92212533retest_ed
retestifying1993413retestifying
retests73813853retest__s
retexturing1952463retexturing
retieing92913713ret_ieing
retiling93319483ret_iling
retiming113014193ret_iming
retiring92717413ret_iring
retitling1039773retitling
retooling1039093retooling
retracing12313293retracing
retracting13311933retracting
retreading12128483retreading
retrying122410453ret_rying
retsina74710603ret_s_ina
retuning9311583ret_uning
returning1038133returning
retying113213833ret__ying
retyping14255613ret_yping
reuniting10310693reuniting
reusing82516783re_us_ing
revealing132611883revealing
reveling123117083reve_ling
revelling132412553revelling
revenging1438083revenging
reverbing15248593reverbing
revering122918073reve_ring
reversing132611483reversing
revising122714403revis_ing
revisiting1446953revisiting
revolting1339633revolting
revoting12312033re_voting
rewashing1676903rewashing
rewearing132310703rewearing
reweaving16227073reweaving
rewedding1535093rewedding
rewelding1436913rewelding
rewriting13310413rewriting
rezeroing1935933rezeroing
riesling939013r_iesling
riposting1236063riposting
riveting12139443rive_ting
rivetting13256413rivetting
roasting93012703r_oasting
roosting93411463r_oosting
rotating92614553rot_ating
rotting82919683rot__ting
rousting93913273r_ousting
russeting1065323russeting
rusting83821263r__usting
rutting82718043rut__ting
selecting12310533selecting
setting83621393set__ting
stetting93410713_stetting
tasting84624213__tasting
tempesting1544453tempesting
tenting84621153__tenting
unresting10311133unresting
vesting114618683__vesting
vetting114216563vet__ting
weeting113816053we_e_ting
westing115020273__westing
wetting114117383wet__ting
wresting123811833_wresting
yeasting12188923ye_asting
zesting174515333__zesting

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.423422437.4
2DLD Change Limit1486413267.26320465.5
3Display Results3263260.1602037.5
 (SQL Overall)1786913267.84622774.8
 
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.