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

136 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
regalia83922(None) 
realia6314591re_alia
regain74517762rega_in
regal65023792regal__
regale74821452regal_e
regaled93615962regaled
regaler83814622regaler
regales83520792regales
regaling10315362regaling
regality1249312regality
regally1159872regally
regatta835962regatta
reguli738142reguli_
vedalia1145682vedalia
angaria8311583angaria
argala74712673argal_a
argali75013753argali_
argalis84214193argalis
begall92610723begal_l
begalls10319163begalls
begonia1047213begonia
degami10279013degami_
degamis11268443degamis
dentalia947533dentalia
egal55119433_egal__
egalite8311563_egalite
gala55635163__gal_a
galea64722943__galea
glia56423153__g_lia
hegari1039523hegari_
hegaris11310433hegaris
legal65715943legal__
legalise949493legalise
legalism1148583legalism
legalist9512393legalist
legality1237623legality
legalize1839103legalize
legally1138133legally
legals73412733legal_s
logania847833logania
mealie82519813me_alie
megabit12117963megabit
megahit1378773megahit
megalith1448243megalith
megara9310093mega_ra
megilla1036273megilla
peculia1147133peculia
qualia1559563_qualia
radialia946323radialia
raia46638383r__a_ia
ratafia1045773ratafia
reagin74915533re_agin
real45750293re_al__
realer63528593re_aler
reales64934123re_ales
realgar834873re_algar
realign838763re_align
realise73021813re_alise
realism93115923re_alism
realist73225383re_alist
reality10313573re_ality
realize162717083re_alize
really93315613re_ally
realm75621623re_al_m
realms84913493re_alms
reals55038653re_al_s
realty92713693re_alty
reata54225393re_a_ta
rebait8320403reba_it
recall83815723recal_l
recalls92613623recalls
reclaim1137753reclaim
redia65524483re__dia
refall94314393refal_l
refalls103312243refalls
refugia1144313refugia
regains84316583regains
regalers94311133regalers
regard85215773rega_rd
regards94112563regards
regattas944473regattas
regauge945813regauge
regave104713383rega_ve
regild8149773regil_d
regilds996673regilds
regilt71217493regil_t
regina75317143reg_ina
reglaze1747223reglaze
reglet73724233reg_let
reglow10339403reg_low
reglue739703reg_lue
regma84612333reg__ma
regmata1036193regmata
regna64614813reg__na
regnal74812933regnal__
regolith1247543regolith
regular838423regular
reguline939503reguline
regulus836523regulus
relaid75518443rela_id
relaxin14239183relaxin
relic74623363re__lic
relit55340683re__lit
remail85017123rema_il
remails94714563remails
remain85919863rema_in
renail65020763rena_il
renails74917263renails
renal55929503renal__
repaid94716323repa_id
repair84011463repa_ir
replica1137943re_plica
reptilia1045163reptilia
resaid74517083resa_id
resail64418733resa_il
resails74616743resails
resale64025543resal_e
resales74724903resales
resilin72913973resilin
resplit9310373resplit
retail65522073reta_il
retails74718973retails
retain64523283reta_in
retaliate9410643retaliate
retally10413683retally
retia55326113re__tia
revalue1038153revalue
rosaria749253rosaria
rugal65916093rugal__
rugola736293rugol_a
sedilia847243sedilia
telia55821143te__lia
trehala1045953trehal_a
vedalias1245153vedalias
velaria1038923velaria
weigelia1242213weigelia

Search took 8 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.406440125.6
2DLD Change Limit1340271367.22018563.3
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.