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 “operands” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
operands114681(None) 
operand1038001operand_
operants1039481operants
operant9317222operan_t
operas8312452opera__s
operates10515412operates
operons91411742operon_s
overhands16227802overhands
overlands13218882overlands
ampersands1552793ampersands
brands95118943__brands
demands114311413_demands
desands94810163_desands
elands74914773__elands
emeralds1144593emeralds
epergnes1156713epergnes
errands847603_errands
forehands1656743forehands
forelands1347173forelands
foreranks1645293foreranks
gerunds935183_gerunds
grands84218243__grands
heralds1137713_heralds
homelands1545453homelands
honorands1345023honorands
monerans10310353moneran_s
nosebands1244083nosebands
oceans81211003oce_an_s
odorants946043odorants
openings1134813openings
opens76118553ope__n_s
opera7313573opera___
operable12410323operable
operably1557093operably
operantly1444913operantly
operate9615733opera_te
operated11512223operated
operatic1249933operatic
operatics1346953operatics
operator10310093operator
operators11410753operators
operon8811773operon__
orangs74116033o__rangs
oreads73915773ore_a_ds
oreganos945553oreganos
ourangs8318503o_urangs
outlands988563outlands
outranks12298823outranks
overacts1339653overacts
overages12513833overages
overalls11410393overalls
overarms13258383overarms
overawes14511183overawes
overbids14248903overbids
overfunds1644593overfunds
overhand15229963overhand_
overhangs16226553overhangs
overland122312003overland_
overlends13237523overlends
overmans13310313overman_s
oversuds1237033oversuds
overwinds1645573overwinds
parangs104314383_parangs
peans75437643_pe_an_s
pecans101515833_pecan_s
pedants10310113_pedants
pekans121710553_pekan_s
penangs10268373_penangs
pends85527193_pe__nds
peracids13310073_peracids
periods10312243_periods
pernods1038483_pernods
perpends13227753_perpends
petards104311153_petards
piranas9912613_piranas
prangs94816233_p_rangs
pranks124814723_p_ranks
puranas9712653_puranas
pyrans11411063_pyran_s
rands65930453___rands
relands85214883_relands
remands104914883_remands
sopranos1046433sop_ranos
speans85417143spe_an_s
spends94714473spe__nds
spirants1088283spirants
sprangs104610053sp_rangs
spreads1039763sprea_ds
strands83711953_strands
superadds1346413superadds
upbraids1343553upbraids
upends9438763upe__nds
uplands1036943up_lands
upstands1144093upstands
uptrends1142833uptrends
veranda1156323_veranda
verandas1246233_verandas

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 Filter1786911461620.406440125.6
2DLD Change Limit146162977.31319986.6
3Display Results97970.0462108.7
 (SQL Overall)178691977.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.