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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
trailerings124294(None) 
trailering1145721trailering_
tailorings1143432t_ailorings
trailerists1153812trailerists
trailerites1154962trailerites
craterings1346003cra_terings
railings93412153_rail__ings
tailings93211673t_ail__ings
tailoring1036403t_ailoring_
trailerist1046153traileri_st
trailerite1055633traileri_te
trailers82912923trailer___s
trailing92916093trail__ing_
trainings10246723trai__nings
ailerons849854__aileron_s
airings83913844__ai__rings
ballerinas1244594_ballerinas
braidings13285904brai__dings
brailing113514794brail__ing_
brailling1247774brail_ling_
brasileins1242644brasile_in_s
brazileins2141794brazile_in_s
briefings1543734br_i_efings
broidering1444674broidering_
brokerings1743284br_okerings
cradlesongs1561194cradlesongs
cratering12312654cra_tering_
daikering1536104_daikering_
drawstrings1651264drawstrings
drillings11285824dr_il_lings
failings123811014_fail__ings
fairings12388194_fai__rings
featherings18105374featherings
frauleins1242664fraule_in_s
frillings13265804fr_il_lings
gatherings15105294_gatherings
graylings1433884grayl__ings
hankerings18244754_hankerings
kaiserins1355104_kaiserin_s
lawyerings1752584_lawyerings
layerings13235684_la_yerings
mailings113011924_mail__ings
niderings1175404__niderings
pairings11398314_pai__rings
plasterings1444744plasterings
quarterings2143724quarterings
railers74420664_railer___s
railing83325644_rail__ing_
railleries1046644_railleri_es
raisings9338444_rai__sings
rallyings13313634_ra_llyings
ravelings13377384_ra_velings
ravellings14214454_ravellings
ravenings13235184_ra_venings
renderings12256084_renderings
sailings93513254_sail__ings
scatterings14103974scatterings
silverings1443844__silverings
smatterings14103844smatterings
straitening1243664straitening_
strangering1345184strangering_
tabering112211424t_a_bering_
tableting1236354t_ableting_
tailers73720184t_ailer___s
tailfins1135444t_ail_fin_s
tailing82923104t_ail__ing_
tailspins1143624t_ailspin_s
tailwinds1342354t_ail_winds
talkings13358404t_a_l_kings
tampering1438454t_ampering_
tangerines1147544t_angerines
tapering112112504t_a_pering_
tattering102212324t_attering_
tiering8315254t__i_ering_
tilings84212794t__il__ings
tillering1037884t_illering_
timberings15124094t_imberings
toileting1036264t_oileting_
traceries11312864tra_ceri_es
tracings112910414tra___cings
trackings16247544tra__ckings
tracklayings2251134tracklayings
traiking132511974trai__king_
trailer73015394trailer____
trailerable1352824trailerable
trailered1045394trailer__ed
trainers83114644trainer___s
training93015864trai__ning_
traipsing1235074trai_psing_
trameling1249054tra_meling_
tramelling1346374tramelling_
tramlines1139844traml__ines
trammeling1544024trammeling_
trapesing1247264tra_pesing_
traplines11310374trapl__ines
trappings14265754tra__ppings
traveling1349054tra_veling_
travelling1456534travelling_
traversing1444804tra_versing_
travertines1444734tra_vertines
trawlers113310204trawler___s
trawling122710784trawl__ing_
triflings13235974tr_i_flings
triggering1343884triggering_
trilling92815964tr_il_ling_
trimerisms1444544tr_imerisms
trimmings14254454tr_i_mmings
trippings14225724tr_i_ppings
trithings13246604tr_i_things
trolleying1442554trolleying_
trollings10286694tr_ol_lings
twillings13234914t_wil_lings
waitering13310714_waitering_
wanderings15215834_wanderings
waterings13229254_wa_terings
weatherings1895264weatherings

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191169.20316170.7
3Display Results1161160.0631841.3
 (SQL Overall)1786911169.68618448.4
 
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.