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

211 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
squama173653(None) 
squamae1845721squamae
squab163810732squa_b
squabs17429322squabs
squad155110792squa_d
squads164410292squads
squall1537992squall
squamate1945782squamate
square154513352square
squark19438112squark
squash1846832squash
squat143720142squa_t
squats153712962squats
squaw17368982squa_w
squawk22385372squawk
squaws18438782squaws
summa94713312s_umma
agama85815573_agama
ama510853303___ama
aqua132813963aqu__a
aquae142212713aqua_e
aquaria1638033aquaria
aquas142412613aqua_s
asrama839193asrama
douma85817703dou_ma
drama85117413_drama
duma75524453_du_ma
equal1449823equa_l
equals1538693equals
equate152012463equate
gama77035513__gama
grama85620283_grama
guava938583_guava
gumma105313103_gumma
iguana735803iguana
jicama1734873jicama
lama66635293__lama
llama799893_llama
louma76213633lou_ma
luma65527523_lu_ma
mama86231583__mama
oquassa1642063oquassa
pajama17317653pajama
panama104213343panama
puma85424123_pu_ma
pyjama20303483pyjama
qua124821973_qu__a
quack203812503_quack
quad144618703_qua_d
quads154515843_quads
quaff201311353_quaff
quag144815943_qua_g
quagga1754143_quagga
quags154613253_quags
quai134420393_qua_i
quail144314363_quail
quais144618393_quais
quake184114643_quake
quaky214310743_quaky
quale143617853_quale
qualia1559563_qualia
qualm163511183_qualm
qualms17317243_qualms
qualmy20285803_qualmy
quamash2144283_quamash
quant143624813_quant
quanta153911333_quanta
quare143920543_quare
quark184614123_quark
quart144027853_quart
quasar1536833_quasar
quash174512163_quash
quasi144015023_quasi
quass144413763_quass
quate144521413_quate
quay164618353_qua_y
quays174612043_quays
quota145111963_quota
ruana5312423_ruana
saga55331173s__aga
sagaman10117553sagaman
salaam8711013salaam
salami8313103salami
samara8313853samara
samba95618773s__amba
same65245643s__ame
samp85733593s__amp
satara6315533satara
sauna54117553sau_na
scam85932353s_cam_
scamp115717313s_camp
scams94423973s_cams
schema1388373schema
scram910621613scram_
scrams105216623scrams
scuba94211593scu_ba
scum85924523scu_m_
scummy15265223scummy
scums95017423scu_ms
scuta75815753scu_ta
seam66645973s_eam_
seaman84015903s_eaman
seams75731663s_eams
seamy105921273s_eamy
sequela1663993sequela
sequoia1644233sequoia
sesame8311013sesame
sham96436353s_ham_
shaman113314273s_haman
shamas113717933s_hamas
shame105726703s_hame
shams105829413s_hams
sifaka1353553sifaka
sigma84513823s_igma
sima64730783s__ima
skua86113153sku__a
skuas95611733skua_s
slam67737973s_lam_
slams74927903s_lams
slum65430513slu_m_
slummy13325863slummy
slump94816633slu_mp
slums74623433slu_ms
smegma1134113smegma
soma65635293s__oma
somata8312383somata
sonata6313223sonata
souari6311373souari
spam85930043s_pam_
spams94922193s_pams
spume95817313spu_me
spumy124610363spu_my
sputa74612963spu_ta
squabby2343283squabby
squalid1737043squalid
squalls1647303squalls
squally1937663squally
squalor1644423squalor
squamates2045593squamates
squamosal2051823squamosal
squamose1944273squamose
squamous1944663squamous
squared173610553squared
squarer163410653squarer
squares163714453squares
squarks20417183squarks
squashy2233843squashy
squatly1946423squatly
squatty1964823squatty
squawks23294883squawks
squeak1935253squeak
squeaks2034523squeaks
squeaky2343073squeaky
squeal1538013squeal
squeals1636503squeals
squeg1588033squ_eg
squegs1675643squegs
squib163710493squ_ib
squibs17317443squibs
squid154211903squ_id
squids16409803squids
squill1537223squill
squilla1635523squilla
squint154214793squint
squire155912453squire
squirm17387663squirm
squirms18376333squirms
squirmy21374283squirmy
squirt153812923squirt
squish1838573squish
squush1833993squush
stamp95217363s_tamp
steam76322923steam_
steams84916903steams
steamy115112373steamy
stemma10328133stemma
stigma9226753stigma
stoma75918273s_toma
strata63616283strata
stroma84313073stroma
struma84313273struma
stum65526013stu_m_
stump94616463stu_mp
stums75320083stu_ms
stupa74112313stu_pa
suave83519873s_uave
suba64926603s_u_ba
sulfa8313923s_ulfa
sum56346013s_u_m_
sumac99514883s_umac
summae103911013s_ummae
summas104313163s_ummas
sumo67326313s_u_mo
sump86331533s_u_mp
sums65837583s_u_ms
sunna55016063s_unna
supra73614253s_upra
sura45740293s_u_ra
surra55521343s_urra
sutra54217933s_utra
sutta54015333s_utta
swam96329983s_wam_
swami105614523s_wami
swamp125015323s_wamp
swamy136714403s_wamy
swum96416823swu_m_
tarama8412723tarama
trauma838803trauma
ulama7711473_ulama
usquabae1941893usquabae
zeugma1842713zeugma

Search took 7 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162116.61017052.3
3Display Results2112110.0762776.3
 (SQL Overall)1786912116.82926166.5
 
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.