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

232 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
detailing11251041(None) 
derailing112011311derailing
detailings12243921detailings
detaining112510471detaining
retailing103214731retailing
bewailing1536062bewailing
deairing10311892de_airing
dealing94323232de_a_ling
defiling132812462de_filing
destaining1267942destaining
detaching1637262detaching
detraining1267672detraining
deviling1311812852de_viling
dovetailing1642512dovetailing
emailing113010042_emailing
entailing1039392entailing
metaling111613722meta_ling
metalling1249592metalling
remailing122412472remailing
renailing102813332renailing
resailing103314252resailing
retailings11265232retailings
retaining102114732retaining
retiling93319482ret_iling
tailing82923102__tailing
ailing74331013___ailing
assailing1036023assailing
attaining1047223attaining
availing1267283_availing
bailing103723523__bailing
befalling15226503befalling
begalling13216493begalling
beguiling1334853beguiling
besmiling1436263besmiling
betaking153010153beta_king
betiding1239913bet_iding
bobtailing1543513bobtailing
brailing113514793_brailing
ceiling103416723ce__iling
curtailing1344603curtailing
darling93418363d__arling
deadline10139053de_adline
dealings103510703de_a_lings
deaning94020473de_a_ning
deashing134210953de_ashing
deaving123814753de_a_ving
debagging1533593debagging
debarking1735383debarking
debarring1335713debarring
debasing12238063deba_sing
debating123213733deba_ting
debiting122511203de_biting
debriding1446483debriding
decamping1734943decamping
decanting132510633decanting
decaying15239453deca_ying
deceiving1635733deceiving
deciding132210833de_ciding
declaiming1644783declaiming
declining13129353declining
decupling1534973decupling
defacing15238683defa_cing
defaming15238463defa_ming
defanging1535333defanging
defatting1436103defatting
defaulting1543393defaulting
defining133711803de_fining
defueling14255093defueling
degassing1234823degassing
deicing11312193de__icing
delating103119603dela_ting
delaying133210973dela_ying
deliming12310373de_liming
demanding14237923demanding
demarking1736773demarking
demasting1338453demasting
demising122012523de_mising
depainting14156153depainting
departing1349513departing
depriving1636403depriving
deraigning1344103deraigning
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
deriding112512933de_riding
deriving132510743de_riving
desalting1138843desalting
desanding12207653desanding
desiring10312143de_siring
despairing1445063despairing
despising13167503despising
despiting13179323despiting
despoiling1445113despoiling
destining11311433destining
detail74516433detail___
detailed10319873detail_ed
detailer9268673detail_er
detailers10257253detailers
details84214043detail__s
detain74617383deta__in_
detains83716093deta__ins
detasseling1362203detasseling
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
deticking1736043deticking
detouring1136973detouring
detoxing1736313det_oxing
detracting1438713detracting
detruding1245193detruding
devaluing1434833devaluing
deveining1436393deveining
develing133212733de_veling
deviating14311083deviating
devilling1436703devilling
devising133111523de_vising
devoicing16145223devoicing
dewaxing20215293dewa_xing
dewooling1444323dewooling
dialing94318173d_ia_ling
dialling10310783d_ialling
disabling1337753disabling
disentailing1484223disentailing
distaining1248903distaining
draining103312673d_raining
drawling13318673d_rawling
eagling91113603_e_agling
eanling81416673_e_anling
enabling1138603_enabling
ensiling9410723_ensiling
entoiling1038483entoiling
exiling15311083_e_xiling
failing113521333__failing
fenagling1434553fenagling
fettling1266773fet_tling
flailing12298923_flailing
hailing113820693__hailing
healing113922963he_a_ling
heiling113616363he__iling
jailing153415843__jailing
mailing102923343__mailing
medaling121912263meda_ling
medalling1346923medalling
metalising1348943metalising
metalizing22511363metalizing
metalline1158733metalline
nailing83419963__nailing
nettling957213net_tling
obtaining1236773obtaining
outsailing1137563outsailing
outwiling1337463outwiling
pealing104123203pe_a_ling
pearling11912013pe_arling
pedaling122412133peda_ling
pedalling1346663pedalling
penciling1437413penciling
periling11316863pe_riling
pertaining1347993pertaining
petaline10314883peta_line
pettling1168213pet_tling
prevailing1656723prevailing
quailing1838403_quailing
railing83325643__railing
reavailing1444873reavailing
rebaiting12311643rebaiting
reboiling12149823reboiling
recalling122211903recalling
recoiling121412413recoiling
redialing11311843redialing
refalling132010423refalling
refiling123116533re_filing
regaining112411083regaining
regaling10315363rega_ling
remaining122212793remaining
reoiling93217213re_oiling
repairing12310013repairing
reraising10313773reraising
resiling93520173re_siling
restabling1337653restabling
retacking1658973retacking
retackling1744433retackling
retagging1236033retagging
retailoring1243733retailoring
retaking133114283reta_king
retallying1464703retallying
retaping113012553reta_ping
retarding111110653retarding
retasting102513413retasting
retaxing162311333reta_xing
retelling102112493retelling
retieing92913713ret_ieing
retiming113014193ret_iming
retiring92717413ret_iring
retitling1039773retitling
retooling1039093retooling
retraining11310243retraining
reviling122917213re_viling
sailing83927373__sailing
sealing83528563se_a_ling
settling978943set_tling
snailing92912973_snailing
stabling112913653_stabling
staining9413373_staining
staling83925423_sta_ling
stalling95116703_stalling
stapling112813153_stapling
starling93017123_starling
stealing93416603stea_ling
tabling103216033__tabling
tailings93211673__tailings
teazling1856573te_azling
tetanising1146173tetanising
tetanizing2068093tetanizing
tiling73426553__t_iling
toenailing1143573toenailing
toiling83219023__toiling
totaling9610303tota_ling
totalling1036523totalling
trailing92916093_trailing
unfailing1337453unfailing
unnailing1037023unnailing
vailing113817943__vailing
vealing114217423ve_a_ling
veiling113615293ve__iling
vetchling1843593vetchling
wailing113620903__wailing
weakling16106763we_akling
weanling12118643we_anling
yealing112716383ye_a_ling
yeanling12107063ye_anling
yearling1297883ye_arling

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.420425454.8
2DLD Change Limit1486412327.42320024.4
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.93622516.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.