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

433 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
squire15591245(None) 
esquire16376591esquire
quire144917121_quire
square154513351square
squired173710051squired
squires163812831squires
squirm17387661squirm
squirt153812921squirt
acquire1835602acquire
enquire16287212enquire
equine151711572equine
esquired18315072esquired
esquires17266202esquires
inquire16227992inquire
quare143920542_quare
quired163711942_quired
quires154015732_quires
quirk184011002_quirk
quirt144624232_quirt
quite144621462_quite
require16148652require
satire63218002satire
shire84727132s_hire
sire46150412s__ire
sluice849512sluice
spire75828692s_pire
squared173610552squared
squarer163410652squarer
squares163714452squares
squark19438112squark
squib163710492squi_b
squibs17317442squibs
squid154211902squi_d
squids16409802squids
squill1537222squill
squint154214792squint
squireen1744382squireen
squirmed2034162squirmed
squirmer1934362squirmer
squirms18376332squirms
squirmy21374282squirmy
squirrel17414522squirrel
squirted1845782squirted
squirter1746512squirter
squirts16348002squirts
squish1838572squish
sucre75019102s_ucre
suite54829562s_uite
sure45447412s_u_re
acquired2044043acquired
acquiree1944603acquiree
acquirer1944093acquirer
acquires1945403acquires
admire949933admire
afire86215913_afire
aquae142212713aqu_ae
aquifer1934883aquifer
aquiver1934753aquiver
aspire8612123aspire
asquint16208323asquint
assure6610773assu_re
attire62412383attire
azure14911483azu_re
bemire103312803bemire
bruise83412873bruise
cire65836373__cire
cruise84314043cruise
cure66149123_cu_re
curie74533033_curie
desire7415303desire
dire56644143__dire
dure56341813_du_re
empire1039313empire
enquired18255793enquired
enquires17276973enquires
enquiry19254043enquiry
entire61617703entire
enure53520223enu_re
equate152012463equate
equid154610323equi_d
equids16439143equids
equines161811593equines
equip16467263equi_p
equips17387193equips
equites162212493equites
equity1838103equity
expire1538023expire
faquir1834313faquir_
faquirs1943863faquirs
fire76245593__fire
glaire74411293glaire
gluier7310263gluier
guide75019883_guide
guile64521133_guile
guiro63712093_guiro
guise64717713_guise
hire75538963__hire
inquired18245933inquired
inquirer17235173inquirer
inquires17237363inquires
inquiry19254703inquiry
inure54119053inu_re
ire36943173___ire
juice14311323_juice
lire47845293__lire
louie55023513loui_e
louvre9425683louvre
lucre76415523_lucre
lure45142463_lu_re
maugre9308973maugre
mesquite19537043mesquite
mire66748223__mire
moire71017313_moire
mure65941333_mu_re
murre74821073_murre
oeuvre932813oeuvre
ourie54027293_ourie
outre53922193_outre
pure65543333_pu_re
quaere154110673_quaere
quake184114643_quake
quale143617853_quale
quark184614123_quark
quart144027853_quart
quarte154115323_quarte
quate144521413_quate
quatre153512353_quatre
queer143712813_queer
quern143610403_quern
query174212083_query
queue143711233_queue
quiche2057903_quiche
quick204311063_quick
quid144922353_qui_d
quids154917463_quids
quiet144530733_quiet
quiff201111553_quiff
quill148413763_quill
quilt144125103_quilt
quin135823923_qui_n
quince173910133_quince
quins144819853_quins
quint144529903_quint
quinte153414523_quinte
quip154818623_qui_p
quips164713373_quips
quipu164811643_quipu
quirked21325423_quirked
quirks19419113_quirks
quirky22435523_quirky
quirted17369203_quirted
quirts154213553_quirts
quit136136513_qui_t
quits144122353_quits
quiver18278743_quiver
quiz224920003_qui_z
quote143714773_quote
refire95419473refire
rehire95415863rehire
required18156833required
requirer17156113requirer
requires17168703requires
requite162012483requite
retire64927013retire
rewire95421403rewire
sabine84020383sabine
sabir75916993sabir_
sabirs85414623sabirs
sabre74821503s_abre
sagier73717163sagier
saice75424053s_aice
saline65132703saline
saltire73113033saltire
samite83020603samite
satires72617573satires
sauce75121653sau_ce
saucer84314103saucer
saucier9810283saucier
sauger74316253sauger
saurel6511983sau_rel
sauries72821623sauries
saury84317223sau_ry
saute55028083sau_te
sautoire844493sautoire
savine94220283savine
scare75334463s_care
score75526733s_core
scribe104613523scribe
scrive115414943scrive
scurf104719323scu_rf
scurry11419583scurry
scute75520943scu_te
secure8513533secure
sedile73517233sedile
seine55732873s_eine
seise54727853s_eise
seize143819503s_eize
sempre102710093sempre
senile63420213senile
sequin1538523sequi_n
sequined18105653sequined
sequins1637863sequins
sere46153473s__ere
serine65432673serine
severe94016083severe
sexier13310683sexier
shaird10288703shaird
shairn9269063shairn
share86437083s_hare
shier85428943s_hier
shine85533093s_hine
shires95225573s_hires
shirk124817843s_hirk
shirr84716923s_hirr
shirt84533893s_hirt
shive114423423s_hive
shore85432643s_hore
shrike134513243shrike
shrine94920053shrine
shrive125216953shrive
shute84520343shu_te
sice65545593s__ice
side55444483s__ide
sike87138783s__ike
simile83115623simile
sine46560623s__ine
sipe67341043s__ipe
sir35746673s__ir_
sired66134283s__ired
siree55238813s__iree
siren54525823s__iren
sires55945373s__ires
sirs44338333s__irs
site47052413s__ite
size135630963s__ize
sizier1514813393sizier
skier95119593s_kier
skirl96012913s_kirl
skirr94810543s_kirr
skirt95624663s_kirt
skite95120043s_kite
skive124614113s_kive
slice74925823s_lice
slide64725413s_lide
slier54827243s_lier
slime74925753s_lime
slipe75626133s_lipe
sludge84811943sludge
slue45332193slu__e
sluiced1046053sluiced
sluices959073sluices
sluicy1166483sluicy
sluing74315883sluing
slur45525153slu_r_
slurb74116323slu_rb
slurp74014983slu_rp
slurred8359183slurred
slurry9378593slurry
slurs54123373slu_rs
smile74823913s_mile
smirk116612743s_mirk
smite75224863s_mite
smudge10387913smudge
snare54429983s_nare
snide64318723s_nide
snipe75320573s_nipe
snore55424953s_nore
soiree62919483s_oiree
sombre10729473sombre
somite84519373somite
sopite84917713sopite
sore47059533s__ore
souari6311373souari
soubise9118793soubise
soupier93111753soupier
sour45935893sou_r_
source8410673source
soured74921863sou_red
sourer63620213sou_rer
sours55230503sou_rs
souse56530773sou_se
souter64225923souter
sozine15712343sozine
spare75135563s_pare
speir75315363speir_
speired103811103speired
speirs85013233speirs
speise84614253speise
sphere113313653sphere
spice95528813s_pice
spier75728033s_pier
spike114922843s_pike
spile75230083s_pile
spine76534423s_pine
spirea84015633s_pirea
spired94921863s_pired
spirem104214163s_pirem
spires84628113s_pires
spirt75032953s_pirt
spiry105017353s_piry
spite75430663s_pite
splice104915103splice
spline86020533spline
splore81611303splore
spore75428593s_pore
sprier84119063sprier
sprite84421773sprite
spue66025523spu__e
spuing94313363spuing
spume95817313spu_me
spumier1137903spumier
spur65321193spu_r_
spurge93711323spurge
spurn74815453spu_rn
spurred103610613spurred
spurrer93710213spurrer
spurrey12307803spurrey
spurry11429113spurry
spurs74621523spu_rs
spurt77227983spu_rt
squab163810733squ_ab
squabs17429323squabs
squad155110793squ_ad
squads164410293squads
squall1537993squall
squama1736533squama
squamae1845723squamae
squarely2045343squarely
squarers17338003squarers
squarest17338213squarest
squarks20417183squarks
squash1846833squash
squat143720143squ_at
squats153712963squats
squaw17368983squ_aw
squawk22385373squawk
squaws18438783squaws
squeak1935253squeak
squeal1538013squeal
squeeze2543593squeeze
squeg1588033squ_eg
squegs1675643squegs
squibbed2283413squibbed
squidded2043713squidded
squiffed2433723squiffed
squiffy2542563squiffy
squiggle1943173squiggle
squilgee1844613squilgee
squilla1635523squilla
squillae1745183squillae
squills1666303squills
squinch2134833squinch
squinny19274213squinny
squinted1847053squinted
squinter1747353squinter
squints16339033squints
squinty19287053squinty
squireens1842723squireens
squiring18177553squiring
squirish2045103squirish
squirmers2053103squirmers
squirmier2042843squirmier
squirrels18333413squirrels
squirrely21283323squirrely
squirters1835063squirters
squished21186383squished
squishes20198383squishes
squishy2244013squishy
squush1833993squush
stair54719933stair_
stairs65416333stairs
stare54440263s_tare
stere55328543s_tere
stile54931573s_tile
stime76521793s_time
stipe76523373s_tipe
stir45723243s_tir_
stirk95717413s_tirk
stirp76815503s_tirp
stirs55921613s_tirs
store56333813s_tore
stoure64814943stoure
stourie7469343stourie
striae65422273striae
stride75420963stride
strife95318363strife
strike105619733strike
stripe85822443stripe
strive95020963strive
studier82510053studier
stuiver10447083stuiver
stupe75217753stu_pe
sturt56028963stu_rt
suave83519873s_uave
suber74924503s_uber
sucres84218893s_ucres
sue35651463s_u__e
suede64419753s_uede
suer45334033s_uer_
suers55128483s_uers
suing65026363s_uing
suint55638183s_uint
suit45649873s_ui_t
suited74019423s_uited
suiter64121813s_uiter
suites63727403s_uites
suits55028053s_uits
supe65932763s_u_pe
super74924483s_uper
supine84216693supine
supra73614253s_upra
sura45740293s_u_ra
surd56433813s_u_rd
surer54833093s_u_rer
surf76039313s_u_rf
surge65027693s_urge
surra55521343s_urra
surrey94414573s_urrey
suspire937803suspire
sutra54217933s_utra
suture6313203suture
sware85828213s_ware
swine85625303s_wine
swipe105217083s_wipe
swirl84514143s_wirl
swive115316193s_wive
swore84920813s_wore
tire46143353__tire
umpire1047883umpire
usque14137733usqu__e
venire93513693venire
wire75839813__wire
zaire14311993_zaire

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127164337.08015920.3
3Display Results4334330.1403092.9
 (SQL Overall)1786914337.39324170.3
 
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.