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

166 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
truanting103560(None) 
granting103514522gr_anting
grunting10269582gru_nting
quanting1849232_quanting
ranting84025412_r_anting
strunting1037872stru_nting
taunting93510932tau_nting
tenanting1036212tenanting
trancing112812022tr_ancing
treating92519612trea_ting
trusting93411652tru_sting
anting75827023___anting
arointing1049363arointing
aroynting1344633aroynting
arranging1156303arranging
blunting11319843blu_nting
branding122513683br_anding
branning112911093br_anning
breasting1239583breasting
bruiting11259973bru_iting
bruting102612993bru__ting
bunting103718833_bu_nting
canting104725903__canting
chanting143413533_chanting
chaunting1555413chaunting
counting113115273cou_nting
crafting143710173cr_afting
craning103620303cr_an_ing
cranking154613073cr_anking
crating103725203cr_a_ting
creating113921953crea_ting
crusting113612793cru_sting
curating11314293cura_ting
daunting103310403dau_nting
decanting132510633decanting
drafting13339403dr_afting
dratting10389653dr_atting
dunting93418383_du_nting
equating18310113equa_ting
eructing112110173eru_cting
erupting11218443eru_pting
flaunting1335043flaunting
franking164310863fr_anking
fronting12310443fr_onting
fruiting12229063fru_iting
grafting13319623gr_afting
grating93923183gr_a_ting
groaning102410283groan_ing
gruntling1134263gru_ntling
hanting114124483__hanting
haunting123510053hau_nting
hunting114317123_hu_nting
incanting1289903incanting
jaunting16328633jau_nting
levanting1345523levanting
lunting83817743_lu_nting
mordanting1444003mordanting
mounting112711813mou_nting
munting103718773_mu_nting
orating83520323or_a_ting
orienting1038723orienting
panting104025423__panting
planting113515383_planting
prancing132612163pr_ancing
pranging123012723pr_anging
pranking153813383pr_anking
prating103424453pr_a_ting
preacting142412533preacting
printing113216083pr_inting
pronating12313763pronating
pruning10311733pru_n_ing
punting103318443_pu_nting
quantong1843493_quantong
rafting113815753_r_afting
ranging94120263_r_anging
ranking124320883_r_anking
rating74938703_r_a_ting
ratting83822363_r_atting
reacting113317893_reacting
recanting122414823recanting
renting84026853_r_enting
roasting93012703_roasting
ruinating1039593_ruinating
ruining83514883_ruin_ing
running83514593_ru_nning
rusting83821263_ru_sting
rutting82718043_ru_tting
scanting113914763_scanting
shunting123610433shu_nting
slanting94115093_slanting
squatting1934513squatting
squinting1936223squinting
stranding1149653str_anding
striating10914193stria_ting
strutting1037003stru_tting
stunting92811503stu_nting
tainting93613583t_ainting
tanging93419523t__anging
tanking123918793t__anking
tanning83618253t__anning
tarting84222653t__arting
tasting84624213t__asting
tatting84019523t__atting
tauting83316383t__auting
tenting84621153t__enting
thanking16409523t_hanking
threating131010053threa_ting
throating1398403throa_ting
thrusting1335013thru_sting
thunking16196953thu_nking
thwarting1632763thwarting
tinting84620603t__inting
toasting93410583t_oasting
tormenting1345693tormenting
touting84118453tou__ting
tracing103720153tr_a_cing
tracking153715463tr_acking
trading93517973tr_a_ding
traiking132511973tr_aiking
trailing92916093tr_ailing
training93015863tr_aining
tramming13279343tr_amming
tramping132711273tr_amping
transiting11410773tr_ansiting
trapanning1343213trapanning
trapping132911393tr_apping
trashing122613223tr_ashing
trawling122710783tr_awling
treading103515333trea_ding
treadling1137503treadling
trending103012833tr_ending
trepanning1344153trepanning
triaging102610543tria_ging
trining82919213tr_in_ing
troaking133310973troa_king
trotting92510913tr_otting
trouncing1235153trouncing
truancies1146883truancies
truant6315783truant___
truanted935373truant_ed
truantly1144643truant_ly
truantries1044023truantries
truantry1142543truant_ry
truants738163truant__s
trucing103211843tru__cing
trucking153310163tru_cking
truckling1645073truckling
trudging11266443tru_dging
trueing83410183tru__eing
truing73913933tru___ing
trumpeting1543573trumpeting
trumping13308733tru_mping
truncating1344233truncating
trundling1135003trundling
trussing9268653tru_ssing
trysting12267053tr_ysting
tufting11289873t_u_fting
tuning74016843t_u_n_ing
tunning83514453t_u_nning
turning83713183t_urn_ing
tutting83515913t_u_tting
twanging13287063t_wanging
urinating10310653urinating
vaunting12338753vau_nting
wanting114220173__wanting
warranting1444743warranting

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 Limit1486411667.23620541.9
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.71923149.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.