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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
return623222521_return
retorn610923422_retorn
returns79712592_returns
brethren1343783brethren
creature1038723creature
cretin82917913cret_in
eremuri944043eremuri
inturn63411563_inturn
nocturn944653nocturn
outturn737123outturn
overturn11157303overturn
perturb1146003perturb
precure11312553precure
prereturn1143393prereturn
preteen939873preteen
preterm11310153preterm
pretor8315743pretor_
pretors9316803pretors
prewarn124410143prewarn
preworn124711213preworn
reborn810016953_reborn
rebury11349213_rebury
recur74116843_recur_
recurs83315803_recurs
reearn6612143_reearn
repugn946493_repugn
requin15310713_requin
rerun58722153_reru_n
retain64523283_retain
retard75018933_retard
retire64927013_retire
retore67630763_retore
retort66831143_retort
retro55020953_ret_ro
retry84718083_ret_ry
retune69121953_retune
returned9459133_returned
returnee8449883_returnee
returner8397983_returner
retuse66617223_retuse
reworn98122193_reworn
taciturn1042653taciturn
teeter65420313teeter_
teeters74018303teeters
tenure6311613t_enure
tern46134803t_e__rn
tertian7511193tertian
tetra53417953t_et_ra
tetri52716453t_et_ri
texture1497083texture
torture738593torture
treason748763treason
treasure846743treasure
treasury1143783treasury
treater74219833treater_
treaters83615823treaters
treen55622753tre__en
tremor84210393tremor_
tremors93711213tremors
trepan82511673tre_pan
tressure846483tressure
tret46653533tret___
trets55928023tret__s
tricorn937963tricorn
triter65120593triter_
triton63914893trit_on
trueborn1043043trueborn
turn46330383___turn
upturn8286243_upturn
ureter6313203ureter_
ureters7311823ureters
urethan1045473urethan
urethra1064153urethra

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027737.89316980.5
3Display Results73730.0302433.3
 (SQL Overall)178691738.07922118.0
 
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.