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

139 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
operand103800(None) 
operands1146811operands
operant9317221operant
opera7313572opera__
operants1039482operants
operas8312452opera_s
operate9615732operate
operated11512222operated
operon8811772operon_
operons91411742operons
overhand15229962overhand
overland122312002overland
ampersand1443793ampersand
brand85124493__brand
demand104314253_demand
desand84812633_desand
eland65820393__eland
emerald1046923emerald
epergne1046143epergne
errand758793_errand
forehand1537693forehand
foreland1239013foreland
foreran10311793foreran_
forerank1546753forerank
gerund836163_gerund
grand75122693__grand
herald10311343_herald
homeland1446233homeland
honorand1246333honorand
iterant7317783iterant
moneran9311113moneran_
monerans10310343monerans
nonbrand1145383nonbrand
noseband1144353noseband
ocean71212963oce_an_
oceans81211003oce_ans
odorant8411393odorant
offhand1742883offhand
oped76230153ope___d
open66427003ope__n_
opened94311863ope_ned
opening1039923opening
opens76118553ope__ns
operable12410323operable
operably1557093operably
operantly1444913operantly
operates10515413operates
operatic1249933operatic
operating12313723operating
operator10310093operator
operose939433operose
orad56031693o__ra_d
orang65119943o__rang
oread64619603ore_a_d
oregano846253oregano
ourang73311063o_urang
outland81212343outland
outran63218893outran_
outrang83813953outrang
outrank112611973outrank
overact12315043overact
overage11514053overage
overaged13511673overaged
overall10411083overall
overapt12312653overapt
overarm12239793overarm
overate10620963overate
overawe13511463overawe
overawed1579973overawed
overbed132811853overbed
overbid132710273overbid
overdid12199173overdid
overed102216623over_ed
overfed142510253overfed
overfond1537323overfond
overfund1535813overfund
overhands16227803overhands
overhang15248863overhang
overhard15238793overhard
overing111918053overing
overkind1637953overkind
overlaid122410383overlaid
overlands13218883overlands
overlend122510103overlend
overman12311463overman_
overmans13310313overmans
overmany1647143overmany
overpaid14158933overpaid
overran10311663overran_
overrank1548113overrank
oversad11259963oversad
overwind1538533overwind
parang93715513_parang
pean66147173_pe_an_
peans75437643_pe_ans
pecan91919033_pecan_
pecans101515833_pecans
pedant9319493_pedant
pekan111613973_pekan_
pekans121710553_pekans
penang92511113_penang
pend75934533_pe__nd
peracid12312993_peracid
period9314983_period
perked134617693_perked
permed115217353_permed
pernod9310453_pernod
perpend12259353_perpend
petard95013803_petard
pirana8713263_pirana
prang84820323_p_rang
prank115019453_p_rank
purana8712933_purana
pyran10514473_pyran_
pyrans11411063_pyrans
rand55839573___rand
reland75920433_reland
remand95618963_remand
repand95316063_repand
reran57329103_reran_
soprani937403sop_rani
soprano937003sop_rano
spean74620513spe_an_
speaned103411523spe_aned
speans85417143spe_ans
speared104314423speared
spend85619333spe__nd
spirant9814293spirant
sprang95713523sp_rang
spread9312533sprea_d
strand74514823_strand
superadd1246653superadd
tolerant8411463tolerant
upbraid1244973upbraid
upend85011043upe__nd
upland938863up_land
upstand1045343upstand
uptrend1044293uptrend
veranda1156323_veranda

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271396.11021935.7
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.54627297.7
 
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.