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

48 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
languages1111505(None) 
langrages11105901langrages
language10105001language_
slanguages12122861slanguages
langrage10106032langrage_
langues81211912langu__es
slanguage11112922slanguage_
angulates10310863_angulates
anlages82414113_an_lages
assuages936273_assuages
baggages1335443ba_ggages
bandages12310633ban_dages
cangues10611823cangu__es
engages92912493_eng_ages
gangues9149753gangu__es
hangtags1344163hangtag_s
lagunes8148523la_gu_nes
landgraves1542673landgraves
langlaufs1342103langlaufs
langoustes1143483langoustes
langridges1342193langridges
langsynes1342843langsynes
langue71012173langu__e_
languet8713693langu__et
languets987243langu_ets
languettes1144643languettes
languishes1444243languishes
languors976153langu_ors
langurs889103langu__rs
lanugos834453lan_u_gos
lavages1138603la__vages
layerages1345303layerages
linages8813173lin__ages
lineages979183lin_eages
linguae8398413lingua_e_
linguals9317223lingua_ls
linguines1046513linguines
linkages1385953lin_kages
luggages1143633l_uggages
manages103418963man__ages
nonlanguages1461603nonlanguages
sanguines1047183sanguines
sublanguages1661323sublanguages
tankages13217113tan_kages
tannages9228963tan_nages
vanguards1443273vanguards
vantages12119023van_tages
wantages12109023wan_tages

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 Filter1786911486410.406440125.6
2DLD Change Limit148641487.11020905.9
3Display Results48480.0163000.0
 (SQL Overall)178691487.53223724.2
 
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.