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

168 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
duals6562008(None) 
dals57145121d_als
deals65435341deals
dhals95415441dhals
dials64925341dials
duads76515341duads
dual55928171dual_
duels65619231duels
dulls64523741dulls
aals49941142_aals
als36663022__als
baals76122702baals
bals66354042_bals
bubals103513842bubals
buhls105111802buhls
bulls75629572bulls
burls74228852burls
cauls75727772cauls
coals76129602coals
culls75425812culls
curls74927102curls
dabs77139402d_abs
dads67442772d_ads
dags66642592d_ags
dahls95012282dahls
dahs88231812d_ahs
dais57040702d_ais
daks97130602d_aks
dal47554952d_al_
dale55643982d_ale
dales66439742d_ales
dams77444372d_ams
dans56748142d_ans
daps77239162d_aps
daubs85014562daubs
dauts67822242dauts
daws86638242d_aws
days87637132d_ays
deads75726912deads
deal56347412deal_
dealt65234282dealt
deans66131392deans
dears65736882dears
decals93717712decals
deils65722862deils
dells66630942dells
dels56745472d_els
dhaks13479702dhaks
dhal86719282dhal_
dial55935062dial_
dills65530972dills
diols65521012diols
dirls64720502dirls
doats65224882doats
dolls66126922dolls
dols56943052d_ols
doulas75114992doulas
drabs85119672drabs
drags75521112drags
drails74716952drails
drams86025832drams
drats66628372drats
drawls105511392drawls
draws95119372draws
drays95819772drays
duad66521412dua_d
dualism1049162dualism
dualist8614052dualist
dually103210062dually
dubs78432192du_bs
ducal84816422ducal_
ducats95011762ducats
duces86327472duces
ducks124823212ducks
ducts85319892ducts
dudes75424372dudes
duds65530142du_ds
duel56729702duel_
dues56045502du_es
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dugs614832282du_gs
duits65021882duits
dukes105023472dukes
dull56430442du_ll
dully94921632dully
dulse65415042du_lse
duly85323032du_ly
dumas85420432dumas
dumbs105915752dumbs
dumps105220102dumps
dunams937832dunams
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432du_ns
dunts65828412dunts
duos56728132du_os
dupes86425932dupes
duple85315862duple
dups75929512du_ps
dural64923892dural_
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
dyads10549972dyads
equals1538692equals
foals85721692foals
fuels87117352fuels
fulls84623522fulls
furls85322052furls
gals57946502_gals
goals65521292goals
guans64419442guans
guars65021042guars
gulls65222982gulls
guls55930852gu_ls
hauls86123732hauls
heals85733452heals
hulas84920882hulas
hulls84923562hulls
hurls86522712hurls
ideals75012502ideals
jouals1338922jouals
luaus54514902luaus
lulls54119652lulls
mauls76524952mauls
meals75933372meals
mulls75124152mulls
murals84016752murals
nulls55019982nulls
nurls55519682nurls
opals75718352opals
orals55826482orals
ovals85413392ovals
pals66951352_pals
peals75235492peals
pulls74425052pulls
puls65437562pu_ls
purls74723352purls
quads154515842quads
quags154613252quags
quails153412642quails
quais144618392quais
quale143617852quale
qualm163511182qualm
qualms17317242qualms
quass144413762quass
quays174612042quays
reals55038652reals
rials55026672rials
sals46851672_sals
sauls55128122sauls
seals54839692seals
sials54227242sials
teals56234132teals
usuals637782usuals
veals84926192veals
vials85822382vials
wauls86120552wauls
weals85428742weals
yuans84613322yuans
zeals145320852zeals

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.1401276364.3
2DLD Change Limit538001682.01626686.5
3Display Results1681680.0762210.5
 (SQL Overall)1786911682.23280058.7
 
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.