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

77 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
lassi5631685(None) 
bassi77019321bassi
lass47444541lass_
lassie64917741lassie
lassis65216701lassis
lasso55015681lasso
asci66519142_asci
ass37844062_ass_
assai5711542_assai
basis75429862basis
bass66146782bass_
basso76017282basso
bassy1012917102bassy
byssi10507992byssi
cassia83714762cassia
cassis84818852cassis
class75525482class_
classic113710112classic
classis93712722classis
classy11379042classy
dashi95013112dashi
dassie74615572dassie
gassy95514022gassy
glass65518132glass_
glassie8329492glassie
glassy10527752glassy
jassid1467222jassid
laari54415712laari
labs67145122labs_
lacs66942482lacs_
lads56549132lads_
lags56546222lags_
lams66552262lams_
lanai5319572lanai
lapis76223152lapis
laps66848872laps_
lapse74917682lapse
lari45839152la_ri
laris54737462laris
lars46956572lars_
las37281472la_s_
lase46148512la_se
lased65132342lased
laser54633322laser
lases54944762lases
lash76539652la_sh
lasses64827592lasses
lassies74420102lassies
lassos64913812lassos
last46260322la_st
lasts57731262lasts
lathi85417202lathi
lati46438272la_ti
lats45962702lats_
lavs76734152lavs_
laws76441682laws_
lays76043252lays_
less45635102less_
loss45337962loss_
lossy85214642lossy
lysis84511462lysis
lyssa835712lyssa
mass66044932mass_
massa75518922massa
masse75125292masse
massif11412532massif
massy104518962massy
oasis56422552oasis
pass65239952pass_
passe75525692passe
passim10410282passim
sass45035622sass_
sassy85813812sassy
tarsi55222172tarsi
tass45640572tass_
tasse54821842tasse
tassie66017022tassie

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 Filter178691538000.346516448.0
2DLD Change Limit53800774.60611680.4
3Display Results77770.0631222.2
 (SQL Overall)178691775.01535631.3
 
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.