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

135 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
retraining1131024(None) 
detraining1267671detraining
pretraining1446501pretraining
refraining1437261refraining
restraining1247531restraining
retaining102114731ret_aining
detaining112510472det_aining
entraining1147642entraining
pertaining1347992pertaining
reattaining1244592reattaining
regaining112411082re_gaining
remaining122212792re_maining
reordaining1343452reordaining
reraising10313772re_raising
retailing103214732ret_ailing
retracing12313292retra_cing
retracking1738162retracking
retracting13311932retracting
straining10410562_straining
training93015862__training
attaining1047223_attaining
betraying1537713betra_ying
braining113414683__braining
curtaining1345533curtaining
deraigning1344103de_raigning
derailing112011313de_railing
destaining1267943destaining
detailing112510413det_ailing
determining1545293determining
detracting1438713detracting
distraining1346983distraining
draining103312673__draining
engraining1245223engraining
graining102813183__graining
hebraizing2545113hebraizing
ingraining1245623ingraining
mistraining1446503mistraining
obtaining1236773obt_aining
outgaining1237093outgaining
outraising1139903outraising
overtraining1646023overtraining
preordaining1652513preordaining
raining83922693___raining
reavailing1444873reavailing
rebaiting12311643re_baiting
recaning111416693re_ca_ning
reclaiming1546583reclaiming
reclining121112283re_clining
recoining121313803re_coining
recrating121318793recra_ting
recrowning1645213recrowning
recruiting1347903recruiting
redbaiting1446263redbaiting
redefining1545423redefining
redlining111210293re_dlining
redrafting1545963redrafting
redrawing1437213redra_wing
redriving1437603redr_iving
reearning1039053re_earning
reexamining2152663reexamining
refining122416863re__fining
refracting1638733refracting
reframing1538623refra_ming
regrading121210203regra_ding
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regra_ting
regreening1246033regreening
regrinding1335703regr_inding
reimagining1542663reimagining
reining84425323re___ining
rejoining17149223re_joining
relearning1135283relearning
relining93218743re__lining
reloaning10710483reloa_ning
relumining1345643relumining
remailing122412473re_mailing
remanning12229033re_manning
renailing102813333re_nailing
reobtaining1443533reobtaining
repainting13128973re_painting
repairing12310013re_pairing
repining114116593re__pining
replanning1345313replanning
repricing14310473repr_icing
reprinting131510583repr_inting
reprising12312553repr_ising
reracking1639313re_racking
rerising93017783re_r_ising
rerunning1036523re_running
resailing103314253re_sailing
reshining13310743re_shining
resining92919553re__sining
restriking1548043restr_iking
restringing1345713restr_inging
restriving1448133restr_iving
retacking1658973ret_acking
retagging1236033ret_agging
retailings11265233ret_ailings
retaking133114283ret_a_king
retaping113012553ret_a_ping
retarding111110653ret_arding
retasting102513413ret_asting
retaxing162311333ret_a_xing
reteaching1636023reteaching
reteaming122110443retea_ming
retearing102214253retea_ring
rethinking1845183ret_hinking
retieing92913713ret__ieing
retiling93319483ret__iling
retiming113014193ret__iming
retinting102215253ret__inting
retiring92717413ret__iring
retrain7615423retra__in_
retrained10411313retrain_ed
retrainee9511163retrain_ee
retrainees1046393retrainees
retrains8314533retra__ins
retreading12128483retreading
retreating111414773retreating
retrieving1445293retrieving
retrimming1544263retrimming
retroacting1447283retroacting
retrofiring1544183retrofiring
retrying122410453retr__ying
retuning9311583ret__uning
returning1038133ret_urning
rewrapping1843343rewrapping
rewriting13310413rewr_iting
spraining1248153_spraining
staining9413373_st_aining
traiking132511973__traiking
trailing92916093__trailing
trainings10246723__trainings
trining82919213__tr_ining

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.406440125.6
2DLD Change Limit1406031357.19019555.4
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.65623340.0
 
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.