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

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

85 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
languishers155259(None) 
languisher1443071languisher_
languishes1444241languishe_s
anguishes1345092_anguishe_s
languished1543122languishe_d
vanquishers2651782vanquishers
anguished1443983_anguishe_d
banishers14258053ban__ishers
blandishers1743003blan_dishers
kingfishers2251713kingfishers
languidness1342323languidness
languish12136253languish___
languishing1653113languishing
languishment1862743languishment
languishments1962273languishments
lavishers1564643la__vishers
lungfishes1743413lungfishe_s
planishers1584773plan__ishers
vanishers15186613van__ishers
vanquisher2552133vanquisher_
vanquishes2542943vanquishe_s
abolishers1543184_abolishers
ambushers1643434_ambu_shers
anguish11117634_anguish___
anguishing1543734_anguishing
ankushes1544584_anku_she_s
banisher13169184ban__isher_
banishes131812464ban__ishe_s
banisters11189474ban__isters
bannisters1244324ban_nisters
blandisher1643464blan_disher_
blandishes1644614blan_dishe_s
canisters112310194can__isters
cannisters1245014can_nisters
clingfishes2052544clingfishe_s
danishes121710494dan__ishe_s
disguisers1244034disguis_ers
englishes1345104_englishe_s
extinguishers2491574extinguishers
finishers1545354fin__ishers
gangbusters1561784gangbusters
gangsters11205734gang__sters
ganisters10248314gan__isters
gannisters1153844gan_nisters
garnishers14174864ga_rnishers
gushers113512514___gu_shers
hagfishes1945154ha_gfishe_s
kingfisher2152244kingfisher_
kingfishes2143704kingfishe_s
ladyfishes2052844ladyfishe_s
lamisters1157124la__misters
lanciers10308544lan_ci__ers
langlaufers1551084langlaufers
langoustes1143484langouste_s
langridges1342194langridge_s
langshans1344284lang__shans
languages11115054langu_age_s
langues81211914langu___e_s
languets987244langu___ets
languettes1144644languette_s
languors976154langu___ors
langurs889104langu____rs
lashers104121834la____shers
laughers1235924la__u_ghers
launchers1454334la__unchers
lavisher1445084la__visher_
lavishes1457404la__vishe_s
lawgivers1641794lawg_i_vers
linguines1046514lingui_ne_s
linguisas1043574linguis__as
linguistics1452984linguistics
linguists1045744linguis__ts
magisters1235804ma_g_isters
nourishers1383634__nourishers
panfishes1737594pan_fishe_s
planisher1495854plan__isher_
planishes14138524plan__ishe_s
punishers1434974pun__ishers
ravishers1564784ra__vishers
sandfishes1745544sandfishe_s
sanguines1047184sangui_ne_s
vanisher14167454van__isher_
vanishes141610754van__ishe_s
vanquished2652164vanquishe_d
varnishers16174344va_rnishers

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 Filter1786911488190.1701051123.5
2DLD Change Limit148819858.30017930.0
3Display Results85850.0461847.8
 (SQL Overall)178691858.51620983.0
 
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.