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

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

66 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
lucres8451330(None) 
luces75528431luc_es
lucre76415521lucre_
lures56138531lu_res
sucres84218891sucres
acres76327762_acres
aures55137092au_res
cures75645432cu_res
duces86327472duc_es
dures65635922du_res
euchres1288662euchres
lacers85225252lacers
laces76141762lac_es
laches116528342laches
lares54852632l_ares
leches115421312leches
liches114724292liches
litres65220392litres
livres94311862livres
locoes85516582locoes
lores55045402l_ores
louvres10356522louvres
lubes74727992lu_bes
lucarnes1045092lucarnes
luce65132572luc_e_
lucern846102lucern
lucernes1046362lucernes
lucerns935752lucerns
lucites9311862lucites
lucked135118022lucked
luckies133313682luckies
lucks115723562luc_ks
ludes65728852lu_des
lues45943552lu__es
lugers74617022lugers
luges65928752lu_ges
lunches124115442lunches
lunes55337772lu_nes
lunges76123422lunges
lunies64723012lunies
lurches123311662lurches
lure45142462lu_re_
lured65427492lu_red
lurer54625312lu_rer
lurers64217492lu_rers
lurex124816732lu_rex
lurks95218742lu_rks
lushes94022742lushes
lustres73013232lustres
lutes55836662lu_tes
lutzes153711922lutzes
luxes124921502lu_xes
lycees11428862lycees
lyches144213612lyches
lycras11287242lycras
lyres85019962l_yres
muches134718992muches
mures75937212mu_res
murres85019042murres
nacres85614452nacres
ouches114322182ouches
puces94924632puc_es
quires154015732quires
ruches114819582ruches
sucre75019102sucre_
ulcers839382ulcers

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 Filter178691825510.250714764.0
2DLD Change Limit82551665.76614316.9
3Display Results66660.0302200.0
 (SQL Overall)178691666.04629555.2
 
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.