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

104 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
hansa8541678(None) 
ansa45927771_ansa
hansas94616041hansas
hanse85722791hanse
ana39559832_an_a
anas46649862_anas
anga56831362_anga
anna45529012_anna
anoa45634472_anoa
ansae55720972_ansae
anta46839582_anta
balsa77920412balsa
banda85223112banda
bans66555142bans_
canna75919332canna
cans65050852cans_
canso75019402canso
canst74932212canst
casa65630862ca_sa
dans56748152dans_
fanga96119632fanga
fans76247372fans_
ganja131410002ganja
hadst93220222hadst
haes77651022haes_
hags86740842hags_
haha107821062ha_ha
hahas117118442hahas
hahs108333362hahs_
haika125313792haika
halma108219262halma
halva115414432halva
hams96446132hams_
hamza19139772hamza
hance105424152hance
hand86833712han_d
handax1749582handax
hands95327382hands
handsaw1435532handsaw
handy125520872handy
hang85535562han_g
hangar104114522hangar
hangs95726732hangs
haniwa1236742haniwa
hank115134142han_k
hanks126226862hanks
hanky155418292hanky
hansel95214372hansel
hanses95022632hanses
hansom11219152hansom
hant75461592han_t
hants86335402hants
haps96443462haps_
harsh116418052harsh
has67372652ha_s_
hash106936502ha_sh
hasp96627292ha_sp
hast76259482ha_st
hats76858252hats_
haws106439442haws_
hawse116015122hawse
hays106138072hays_
henna84414042henna
hens75642572hens_
hins76448002hins_
honda9414982honda
hons77350782hons_
huns76136932huns_
kana85928552kan_a
kanas95326922kanas
khans124615172khans_
mana65341962man_a
manas76240432manas
manga85026212manga
mania75634152mania
manna75522542manna
mans66354552mans_
manse75528232manse
manta75629912manta
masa65034722ma_sa
massa75518922massa
mensa75318672mensa
nana46632902nan_a
nanas55928632nanas
nans46139402nans_
paisa76021072paisa
panda85022612panda
panga85323542panga
pans65855732pans_
pansy105717972pansy
salsa56718922salsa
sanga66023802sanga
sans45153362sans_
sansar63613402sansar
sensa54117472sensa
tanga64923712tanga
tanka93817492tanka
tans46154832tans_
tansy84514942tansy
vanda94515922vanda
vans76236742vans_
vasa76522972va_sa
wans76452272wans_
zanza1378702zanza

Search took 2 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.313570897.8
2DLD Change Limit538001041.42037887.3
3Display Results1041040.0333151.5
 (SQL Overall)1786911041.766101184.0
 
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.