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

157 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
injury1626614(None) 
injure133410861injure
incur72212252incur_
incurs83012272incurs
injured15339062injured
injurer14318472injurer
injures143111172injures
inquiry19254702inquiry
insure63416602insure
inturn63411562inturn
inure54119052in_ure
inurn53712862in_urn
jury146719592__jury
nonjury1744022nonjury
reinjury1842602reinjury
abjure1536733abjure
adjure1435833adjure
angary10311323angary
angry9310863an_gry
augury10366663augury
binary11312223bin_ary
bindery13459833bindery
bury95633593__bury
century1237193century
cindery13429193cindery
conjure16109063conjure
decury1277963decury
endure74014143endure
enduro7338623enduro
enjoy1545963enj_oy
enquiry19254043enquiry
ensure63416003ensure
entry82414263en_try
enure53520223en_ure
finery124512893fin_ery
fleury12417353fleury
floury12449573floury
fury107727973__fury
gingery12368903gingery
immure1036033immure
impure1038383impure
inarm7314423in_arm
inborn8319133inborn
inburst937163inburst
inby95315663in__by
incony1139083incony
incubi1035113incubi
incult82414773incult
incurve1236633incurve
incus73315053incu_s
incuse83513573incuse
indri6310793in_dri
induce93811533induce
induct93212743induct
indue63516673indu_e
indued83411653indued
indues73515263indues
indult73614033indult
industry1243573industry
inert53234373in_ert
infamy1435643infamy
infare9313083infare
infer84215033infer_
infers93615443infers
infirm1137043infirm
inform11310153inform
infra838643in_fra
infuse93110573infuse
ingulf10310353ingulf
inhere9313713inhere
inhume1196583inhume
inject153210233inject
injurers15286123injurers
injuries1567673injuries
injuring1637473injuring
inker94421093inker_
inkers104018833inkers
inky115321583in__ky
inlay85214323in_lay
inly75622213in__ly
inner54920633inner_
innerly1037133innerly
inners63919353inners
inpour837063inpour_
inpours936413inpours
input7314653inpu_t
inputs837703inputs
inquire16227993inquire
inro45920793in__ro
inrun52911373inru_n
inruns6359513inruns
inrush936513inrush
insert64325253insert
insult62813673insult
insured83714253insured
insurer73312803insurer
insures73117263insures
inter55028493inter_
intern64016543intern
inters64328043inters
intort6418923intort
intro54915853in_tro
intuit6314083intuit
inturns73210133inturns
inured73114813in_ured
inures63318953in_ures
inurns63310983in_urns
invar839513invar_
invars9310003invars
invert94120083invert
inward10310333inward
ivory1137373i_vory
jura116024893__jura
kaury12429763_kaury
knarry1334613knarry
knaur9508253knaur_
knaurs10466963knaurs
knur85311973kn_ur_
knurl9398913kn_url
knurly13405533kn_urly
knurs94511153kn_urs
loury85716753_loury
luxury1642543luxury
nary76931223_n_ary
nitery94412173nitery
noninjury1952033noninjury
nurd56224343_n_urd
nurl45327243_n_url
onery8414123on_ery
penury1148103penury
perjury19244253perjury
pinery115214293pin_ery
rebury11349213rebury
reinjure1544983reinjure
saury84317223_saury
sneery93610413sneery
snouty9419953snouty
stoury9529943stoury
tilbury1242973tilbury
tindery11389363tindery
unary8315993un_ary
unbusy1135213unbusy
uncurb1037043uncurb
uncurl839413uncurl
unduly1037823unduly
unfurl937953unfurl
unhurt9311253unhurt
unjust1337873unjust
unpure82911533unpure
unruly938083unruly
unsure62815413unsure
unwary1239823unwary
usury887623_usury
vinery124912603vin_ery
winery125014283win_ery
wintery13399753wintery
wintry12498923win_try

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 Filter1786911127160.203880251.2
2DLD Change Limit1127161576.22018121.5
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.48627550.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.