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

58 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
blindage124368(None) 
blindages1343661blindages
bandage11311022b_andage
bondage1138252b_ondage
linage7713402_lin_age
lindane839032_lindane
lineage878982_lineage
linkage1295962_linkage
windage1237932_windage
alidade936993ali_dade
alienage945583alienage
badinage1294923badin_age
bandaged1337313b_andaged
bandager1237703b_andager
bandages12310633b_andages
binate8419773b_in_ate
bindable13169623b_indable
bindle94516263b_ind_le
binge85125513b_in__ge
birdcage1443513b_irdcage
blende95413443blend__e
blind86319323blind___
blinded114810023blind_ed
blinder103912983blind_er
blinders113911143blinders
blindest11609093blindest
blindgut1242453blindgut
blinding123210163blinding
blindly1335743blind_ly
blinds95111613blind__s
blindside1342753blindside
blinkard1543043blinkard
blintze1833903blin_tze
blockage1744103blockage
blonde94813293blond__e
blondine1137153blondine
bludge104210973bl_ud_ge
blunge94311483blun__ge
bondages1237893b_ondages
bridge103711883bri_d_ge
brigandage1551353brigandage
brindle104210103brind_le
clientage1242713clientage
coinage10310553coin_age
incage93513623__incage
innage73011573__innage
linages8813173_lin_ages
lindanes939173_lindanes
lineages979183_lineages
lineate7815153_lineate
linkages1385953_linkages
mintage101110123_mintage
poundage1244023poundage
sinkage1287263_sinkage
slippage13103943slippage
spinage10289653spin_age
vintage11128143_vintage
windages1338263_windages

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162588.58017035.2
3Display Results58580.0301933.3
 (SQL Overall)178691588.76620384.6
 
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.