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

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

178 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
alaskas113668(None) 
alaska1036711alaska_
abakas123911742aba_kas
abasias9711012abasias
aplasias10279232aplasias
flasks13488672flask_s
plasmas113010752plasmas
abacas104414723aba_cas
abaka114313823aba_ka_
abasers95311973abasers
abases85720773abas_es
abashes12510373abashes
abasia8712953abasia_
abayas114011703aba_yas
acacias11510393acacias
acrasias1048893acrasias
agamas97413443aga_mas
alack114820063alack__
alamedas1145443alamedas
alamos8415003ala_mos
alands75418373ala_nds
alanins7315803alanins
alans55636173ala__ns
alants67722023ala_nts
alanyls1084353alanyls
alarms85913053ala_rms
alarums9408923alarums
alas46358123al___as
alastor739653alastor
alastors8311193alastors
alates64833963ala_tes
albas75925393al__bas
albatas938373albatas
alexias14249793alexias
alfakis1475073alfakis
alfalfas1441953alfalfas
alfas87219043al__fas
algas65624933al__gas
alias55834603al__ias
aliases7914493alias_es
aliyas93911803al_iyas
almas76629773al__mas
almsman1145093almsman
alohas9411703al_ohas
alpacas1137073alpacas
alphas1139513al_phas
alsikes1137263alsikes
altheas1038223altheas
amass77119683amas__s
amasses93912853amasses
amusias938573amusias
anabas8314083ana_bas
anankes1138763anankes
anlases72514903anlas_es
aphasias132710433aphasias
aplasia92510803aplasia_
araks94820883ara_k_s
aristas7413523aristas
asanas6514113asa_nas
askos95011773__askos
asks85721213__ask_s
astasias8410143astasias
ataxias14189343ataxias
atlases72410643atlas_es
awakes135012473awa_kes
azaleas1636993azaleas
baaskap1542513baaskap
baaskaps1641953baaskaps
babkas146010143_babkas
balases93815433balas_es
balatas9311833bala_tas
balsas86417523bal_s_as
basks115621763_bask_s
blacks144914953black_s
blanks124112893blank_s
blasts85116773blas_ts
calashes13310533calashes
calesas9411823cales_as
canastas1037693canastas
casas75327843_cas_as
casks115720063_cask_s
charkas164810953charkas
clacks144516343clack_s
clanks124615183clank_s
clarkias1444793clarkias
clashes124017283clashes
clasps104512093clas_ps
class75525483clas__s
classes94717943classes
classis93712723classis
clasts84817293clas_ts
dalasis8810533dalas_is
damasks1435073damask_s
elastase845643elastase
flacks154114533flack_s
flakes134118873fla_kes
flanks133913403flank_s
flashes133916103flashes
flask125512423flask__
flasket1439733flasket
flaskets1534603flaskets
flautas1036153flautas
galabias1137733galabias
galangas1046173galangas
galateas937123galateas
glass65518133glas__s
glasses84414273glasses
glossas8438193glossas
halachas16317883halachas
halakah17517953hala_kah
halakahs18426633hala_kahs
halakhas18386723halakhas
halalas104214083hala_las
kabakas12367403kaba_kas
kakas85117343_ka_kas
kanakas10327213kana_kas
kashas133311903_kashas
lacks116129203_lack_s
lakes95737653_la_kes
lakhs125210343_la_khs
lamas75532793_la_mas
lamias85020613_lamias
lampas106615953_lampas
larks95227813_lark_s
larvas9310233_larvas
lascar868573_lascar
lascars979013_lascars
lasers64925703_lasers
lases54944763_las_es
lashes94831003_lashes
lashkar1443703_lashkar
lashkars1543673_lashkars
lass47444543_las__s
lasses64827593_lasses
lassis65216703_lassis
lassos64913813_lassos
lasts57731263_las_ts
latkes104715873_latkes
lauras63414333_lauras
lavas85422223_la_vas
llamas888973lla_mas
lyssas935443_lyssas
malaccas1445163malaccas
malangas1136863malangas
malarias10313753malarias
malvasias14154623malvasias
marascas1247383marascas
markas124717003_markas
masas75630413_mas_as
masks115320533_mask_s
massas85116463_massas
miasmas1167743miasmas
palabras1267353palabras
palapas11311493pala_pas
palookas1443843palookas
parkas125018023_parkas
pashas115117063_pashas
pastas85422873_pastas
placks144414153plack_s
planks124116753plank_s
plashes124417393plashes
plasma103810913plasma_
plasms103711333plas_ms
playas114612283pla_yas
plazas17409913pla_zas
salsas65316133sal_s_as
skas85325713___skas
slacks124416533slack_s
slakes104021883sla_kes
slashes103619103slashes
takas95520683_ta_kas
talookas1243113talookas
talukas11316213tal_ukas
tamashas13135683tamashas
tankas104613763_tankas
tasks94917583_task_s
ulamas8910453ula_mas
yamalkas1743103yamalkas

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271787.86017051.8
3Display Results1781780.0602966.7
 (SQL Overall)1786911788.07622126.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.