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

61 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
instanced124569(None) 
instance1049871instance_
instances1148741instances
distanced1348572distanced
inspanned1242852inspanned
installed1045842installed
instancies1246612instancies
instancy1346562instanc_y
instanter946242instanter
instarred1043962instarred
instated91613342insta_ted
distance11311853distance_
distances12311653distances
enhanced1436623en_hanced
ensconced1443343ensconced
entranced1247393entranced
financed1435113fin__anced
incanted11259543in_canted
inkstand1343803inkstan__d
inlaced10239873in_la_ced
insane6314883ins_an_e_
insaner7310443ins_an_er
insnared956123insna_red
instable10313203instable_
installer945003installer
instancing1344643instancing
instant7815343instan__t
instantly1256013instantly
instants8910153instan_ts
instate71616483insta_te_
instates81615833insta_tes
instilled1045293instilled
instinct1048723instinc_t
instincts1144533instincts
instructed1345633instructed
insurance1147443insurance_
insurances1246853insurances
inswathed1642963inswathed
intended102310413in_tended
intoned8811993in_ton_ed
islanded1035513i_slanded
issuance1045213issuance_
issuances1144643issuances
nuanced1036203_n_uanced
stance84316913__stance_
stances93715963__stances
stanched14208903__stanched
staned74824643__stan_ed
stanged94113843__stanged
unnuanced1243413unnuanced
unscanned1245133unscanned
unstacked1636433unstacked
unstained1038683unstained
unstalked1435523unstalked
unstamped1454603unstamped
unstarred1036363unstarred
unstated91615813unsta_ted
unstayed12168393unsta_yed
unstinted1038563unstinted
unstoned9311043unston_ed
untanned9279963un_tanned

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641616.20323962.8
3Display Results61610.0302033.3
 (SQL Overall)178691616.38927968.5
 
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.