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

95 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
visioned124701(None) 
envisioned1452932envisioned
fissioned1345522fissioned
lesioned936902lesioned
missioned1248602missioned
pinioned1137512pinioned
vision9311312vision__
visional1146662visional
visions10311022vision_s
visited1168772visi_ted
visored1138142vis_ored
assigned1044633assigned
basined10310003basi_ned
bastioned1246863bastioned
bishoped1644663bishoped
cosigned1235723cosigned
cushioned1543113cushioned
decisioned1444143decisioned
designed1136943designed
discoed11312483disco_ed
disjoined1845833disjoined
dislimned1344623dislimned
disowned1336433disowned
disposed12310943disposed
disrobed1238093disrobed
disyoked1745463disyoked
divined12329693divi_ned
fashioned16114463fashioned
histone10312843histone_
histones11312803histones
imponed12279453_imponed
intoned8811993_intoned
ironed74916013_i_roned
lessoned945393lessoned
listened9168813listened
masoned1039803mas_oned
misatoned1246693misatoned
miscoded1437983miscoded
miscoined1448443miscoined
misdone10310863misdone_
misjoined1945453misjoined
mismoved1635653mismoved
missioner1147883missioner
mistuned1157723mistuned
misyoked1834623misyoked
motioned1137453motioned
opinioned1243273opinioned
optioned1146383optioned
pavilioned1652493pavilioned
pensioned1246653pensioned
pistoled11259593pistoled
poisoned1136953pois_oned
previsioned1744263previsioned
prisoned1138813pris_oned
provisioned1753973provisioned
rationed9410093rationed
resigned1038863resigned
resined84522653resi_ned
ribboned1343973ribboned
rosined84911903rosi_ned
signed83413753__signed
sinned73818413__sinned
siphoned1446413siphoned
stoned75923143__stoned
tensioned1045613tensioned
unsigned1037563unsigned
unstoned9311043unstoned
veined104413913v_ei_ned
vilified1547243vilified
vilipend1442523vilipend
vined95626153v__i_ned
vinified1537543vinified
violone1037153violone_
violones1137383violones
virion9310683virion__
virions1039873virion_s
visaed104110503vis__aed
visaged1235683vis_aged
viscoid1337023visco_id
viscose1237863viscose_
viscoses1338343viscoses
vised95518763vis___ed
viseed105310983vis__eed
visible1236923visible_
vising103915873visi_n_g
visionary1544033visionary
visioning1347063visioning
visionless1342963visionless
visiter1038863visi_ter
visive1257873visi_ve_
vistaed1138023vis_taed
vitiated12289223vitiated
vitrioled1343423vitrioled
vivified1845893vivified
vizored2034133vi_zored

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 Filter1786911461620.423422437.4
2DLD Change Limit146162956.54622328.4
3Display Results95950.0303166.7
 (SQL Overall)178691956.99925530.9
 
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.