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 “detraining” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
detraining126767(None) 
detaining112510471det_aining
retraining11310241retraining
deraigning1344102de_raigning
derailing112011312de_railing
destaining1267942destaining
detailing112510412det_ailing
determining1545292determining
detracting1438712detracting
distraining1346982distraining
draining103312672d__raining
entraining1147642entraining
pertaining1347992pertaining
pretraining1446502pretraining
refraining1437262refraining
restraining1247532restraining
retaining102114732ret_aining
straining10410562_straining
training93015862__training
attaining1047223_attaining
betraying1537713betra_ying
braining113414683__braining
curtaining1345533curtaining
datelining1244363datelining
deadlining1364563deadlining
deairing10311893de__airing
deaning94020473de__a_ning
debriding1446483debr_iding
debruising1443523debruising
declaiming1644783declaiming
declining13129353de_clining
decrowning1743593decrowning
defining133711803de__fining
defragging1742823defragging
defrauding1642923defrauding
defraying1735853defra_ying
degrading13137373degra_ding
demeaning1337243demea_ning
deorbiting1445153deorbiting
depainting14156153de_painting
deplaning1338053depla_ning
depraving1635973depra_ving
depriving1636403depr_iving
deranging1238063de_ranging
derating103222283de_ra_ting
deratting1139513de_ratting
deriding112512933de_r_iding
deriving132510743de_r_iving
despairing1445063despairing
destining11311433de_stining
detaching1637263det_aching
detailings12243923det_ailings
dethroning1544743dethroning
detrain8412253detra__in_
detrained1158913detrain_ed
detrainment1495383detrainment
detrains9411763detra__ins
detruding1245193detr_uding
deveining1436393de_veining
disdaining1345993disdaining
distaining1248903distaining
engraining1245223engraining
graining102813183__graining
hebraizing2545113hebraizing
ingraining1245623ingraining
mistraining1446503mistraining
obtaining1236773obt_aining
outgaining1237093outgaining
outraising1139903outraising
overtraining1646023overtraining
raining83922693___raining
reattaining1244593reattaining
regaining112411083re_gaining
remaining122212793re_maining
reordaining1343453reordaining
reraising10313773re_raising
retailing103214733ret_ailing
retracing12313293retra_cing
retracking1738163retracking
retracting13311933retracting
spraining1248153_spraining
staining9413373_st_aining
traiking132511973__traiking
trailing92916093__trailing
trainings10246723__trainings
trining82919213__tr_ining

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.423422437.4
2DLD Change Limit140603866.28322378.3
3Display Results86860.0302866.7
 (SQL Overall)178691866.73626527.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.