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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
massa7551892(None) 
masa65034721ma_sa
masas75630411masas
mass66044941mass_
massas85116461massas
masse75125291masse
massy104518961massy
amass77119682amass_
ansa45927772_ansa
asea46327182_asea
ass37844062_ass_
assai5711542_assai
assay8710282_assay
balsa77920412balsa
bass66146782bass_
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
casa65630862ca_sa
casas75327842casas
cassia83714762cassia
fossa85812632fossa
gassy95514022gassy
hansa85416782hansa
kasha124710732kasha
lass47444542lass_
lassi56316852lassi
lasso55015682lasso
lyssa835712lyssa
macs86742512macs_
mads76845382mads_
maes66948402maes_
mafia104418032mafia
magma104513582magma
mags75444532mags_
maist75535682maist
mama86231602ma_ma
mamas95930782mamas
mamba116317522mamba
mamma86317922mamma
mana65341962ma_na
manas76240432manas
manga85026212manga
mania75634152mania
manna75522542manna
mans66354552mans_
manse75528232manse
manta75629912manta
maps86141052maps_
mara67444582ma_ra
maras75443302maras
maria75032892maria
marka114620802marka
mars66261872mars_
marse76231152marse
marsh105320852marsh
mas58175822ma_s_
masala8311822masala
maser75029972maser
mash96039402ma_sh
mashy136016502mashy
mask105227362ma_sk
masks115320532masks
mason74820182mason
massage1039892massage
massed94421322massed
masses85028712masses
massif11412532massif
mast65959962ma_st
masts77035762masts
mats65460292mats_
matsah1138232matsah
matza16311812matza
maws96437142maws_
maya95824592ma_ya
mayas105924382mayas
mays96940032mays_
mayst106622672mayst
mensa75318672mensa
mesa67025482m_esa
mesas76823202mesas
mess65932432mess_
messan83912062messan
messy104913832messy
miasma1097562miasma
miss65339432miss_
missal84314902missal
missay114112142missay
missy105617562missy
moss67641032moss_
mosso74715182mosso
mossy105217062mossy
musca9311762musca
muss64933762muss_
mussy104117642mussy
omasa749482oma_sa
ossa43714162_ossa
paisa76021072paisa
pasha105417182pasha
pass65239952pass_
passe75525692passe
pasta76624532pasta
salsa56718922salsa
sass45035622sass_
sassy85813812sassy
tass45640572tass_
tasse54821842tasse
vasa76522972va_sa
vassal979242vassal

Search took 3 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.390458182.1
2DLD Change Limit538001092.20324421.2
3Display Results1091090.0631730.2
 (SQL Overall)1786911092.65667278.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.