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

137 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
draftings1433421(None) 
drafting13339411drafting_
crafting143710172crafting_
draftiness1444862draftiness
dratting10389662dratting_
drawings13386282dra_wings
drifting13338732drifting_
grafting13319622grafting_
gratings103910762gra_tings
rafting113815752_rafting_
ratings84217412_ra_tings
shaftings16224182shaftings
actings104512463__actings
antings85015583__antings
bastings114214693_bastings
battings114010573_battings
beastings12387653beastings
beatings114113233bea_tings
blastings12347913blastings
boatings113710113boa_tings
bracings13369293bra_cings
braidings13285903braidings
brandings13277483brandings
castings113614053_castings
coastings12357863coastings
coatings113811843coa_tings
crackings18346843crackings
craftiness1545753craftiness
crating103725203cra_ting_
cravings14428223cra_vings
crestings12298043crestings
daffing15369733d_affing_
dampings14377523d_ampings
darings93713653d_a_rings
darklings1533983darklings
darlings103710383d_arlings
darnings10378553d_arnings
darting94020663d_arting_
dating85326483d_a_ting_
dauting93814763d_auting_
dawting123610673d_awting_
deafenings1562503deafenings
dealings103510703dea_lings
derating103222283dera_ting_
deratting1139513deratting_
dialings10329823dia_lings
diallings1134993diallings
doating93816863doa_ting_
drabbing14286803drabbing_
draftees12225253draft_ees
drafters12338533draft_ers
draftier1285263drafti_er
draftiest1335943draftiest
draftily1534413drafti_ly
drafts105012533draft___s
dragging12308103dragging_
draglines1145993draglines
draining103312673draining_
drains73719403dra__in_s
dramming14347573dramming_
draping114213353dra_ping_
drawing123812053dra_wing_
drawling13318673drawling_
drawstrings1651263drawstrings
draying123813843dra_ying_
dredgings13252953dredgings
dressings11265373dressings
driftingly1843673driftingly
driftpins1541833driftpin_s
drillings11285823drillings
drinkings15244773drinkings
drippings15313903drippings
drivings13265763dr_ivings
droppings15264503droppings
drubbings15262883drubbings
ductings12346673d_uctings
dustings10419033d_ustings
eastings93412953_eastings
eatings84616443_ea_tings
fastings124011943_fastings
fraggings15324243fraggings
framings14338133fra_mings
frayings15325993fra_yings
frostings1335733frostings
gatings95212823_ga_tings
granting103514523granting_
grating93923183gra_ting_
gratins84119183gra_tin_s
graylings1433883graylings
grazings19337263gra_zings
greetings11276043greetings
grifting13299263grifting_
hafting144014173_hafting_
kartings13418523_kartings
lastings94214423_lastings
matings104516213_ma_tings
mattings11369673_mattings
orating83520323ora_ting_
partings113513743_partings
plaitings12296243plaitings
plantings12348403plantings
platings113611363pla_tings
prating103424453pra_ting_
printings12268113printings
racings105015133_ra_cings
railings93412163_railings
raisings9338443_raisings
rankings13389173_rankings
ranting84025413_ranting_
raspings11337853_raspings
ratfinks1542853_ratfinks
ratines75328583_ra_tines
rating74938703_ra_ting_
ratting83822363_ratting_
rattlings10235513_rattlings
ravings114614503_ra_vings
redrafting1545963redrafting_
riflings12227313_riflings
rifting113515003_rifting_
saltings92811253_saltings
seatings93614303sea_tings
shafting15278683shafting_
siftings12236583_siftings
skatings13326993ska_tings
slatings94011723sla_tings
slattings10346073slattings
tattings9408823_tattings
tracings112910413tra_cings
trackings16247543trackings
trainings10246733trainings
trappings14265753trappings
triflings13235983triflings
tuftings12264323_tuftings
wafting143911663_wafting_
waitings123413743_waitings
wrappings17253713wrappings
writings12298113wr_itings

Search took 9 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.423422437.4
2DLD Change Limit1486411377.54619698.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.01522294.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.