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

226 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
discern103849(None) 
discerns1138161discerns
cistern93310692cistern
decern91310952d_ecern
dicer85426422di_cer_
dicers94720742di_cers
discard11310212discard
disced104914652disce_d
discept12310622discept
discerned1347862discerned
discerner1246942discerner
discord1139992discord
dissert83720692dissert
viscera1235082viscera
astern64815813_astern
bicorn103610103bi_corn
bister84922763bister_
bisters93922603bisters
bittern94810683bittern
casern84713313cas_ern
cicero1048503ci_cero
cisterna10376353cisterna
cisterns10369563cisterns
cithern12489913cithern
cittern9339133cittern
concern113011963concern
dancer94817613dancer_
dancers103413093dancers
dasheen1136393dasheen
dasher104318983dasher_
dashers115016863dashers
decerns10119053d_ecerns
deicer94114413deicer_
deicers103612733deicers
descend11248153descend
descent102616293descent
descry1256183desc_ry
desert72725493des_ert
dessert82916453dessert
dialer74315433dialer_
dialers83614293dialers
diaper94513113diaper_
diapers104713893diapers
diaster82813313diaster_
diasters92913173diasters
dibber114614713dibber_
dibbers124013173dibbers
dice75841893di_ce__
diced95824683di_ce_d
dices86434243di_ce_s
dicey114819333di_ce_y
dicier94416233dicier_
dicker134521403dicker_
dickers144117663dickers
diester83013683diester_
diesters92513593diesters
dieter73516773dieter_
dieters83216423dieters
differ133910843differ_
differs14339973differs
digger94616083digger_
diggers104413383diggers
diker105524553di_ker_
dikers114418793di_kers
dimer85625603di_mer_
dimers94321093di_mers
dimmer114112613dimmer_
dimmers123811563dimmers
diner65632903di_ner_
dinero75612643di_nero
diners75525953di_ners
dinger85323673dinger_
dingers94321383dingers
dinner74217163dinner_
dinners83915443dinners
diocesan1142913diocesan
diocese1036853diocese
dipper114017783dipper_
dippers123615173dippers
diptera1037203diptera
dipteran1146193dipteran
dipteron1145593dipteron
direr64927073di_rer_
disarm9310473dis_arm
disbar938513disbar_
disbars10310323disbars
disc76123233disc___
discant103017253discant
discards1238913discards
discase102912863discase
discepts1336743discepts
discerners1345703discerners
discerning1447863discerning
disci85815023disc__i
discing113914593discing
disco85616073disc__o
discoed11312483discoed
discoid11311243discoid
discoing12511453discoing
discords1238593discords
discos94915213disc_os
discount11811313discount
discover1439563discover_
discovers1538153discovers
discovert1548793discovert
discovery1845273discovery
discreet11413183discreet
discrete11410283discrete
discrown1445283discrown
discs85316263disc__s
discus94512113disc_us
discuss10357953discuss
disdain938513disdain
diseur738843dis_eur
diseurs839403diseurs
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishier113613403dishier_
dishpan13105523dishpan
disject17268673disject
disjoin1547643disjoin
disked125015763diske_d
dislimn1056103dislimn
disme85716243disme__
dismes95617673disme_s
disown1036953dis_own
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispend11289413dispend
disperse111011353disperse
disport101015953disport
disseat83816923disseat
dissect103614133dissect
dissed85220183disse_d
dissent84018683dissent
disserts92411813disserts
disserve1287443disserve
disses75225963disse_s
distain8313783distain
distend93312073distend
distent84120853distent
distort81120333distort
disturb1046233disturb
ditcher134012003ditcher_
ditchers143610363ditchers
dither104417683dither_
dithers114016153dithers
dithery14318943dithery
ditsier83010293ditsier_
diver94827803di_ver_
divers105024963di_vers
divert103922813di_vert
dizen155214933di_ze_n
doser66228563dos_er_
dosers75723633dos_ers
dosser74417973dosser_
dossers84516233dossers
duster74919723duster_
dusters84918353dusters
eastern74412533eastern
eiswein1043503eiswein
fisher124917143fisher_
fishers134714723fishers
fishery16397733fishery
gittern8337503gittern
hisser94713793hisser_
hissers104112313hissers
intern64016543_intern
kisser104212453kisser_
kissers114211293kissers
lisper84114433lisper_
lispers94514323lispers
listen64816813liste_n
lister64527253lister_
listers74026523listers
lucern846103_lucern
mincer104017363mincer_
mincers113714843mincers
miscoin11311433miscoin
miser75430403mis_er_
misers85025703mis_ers
misery114113543mis_ery
mislearn1045343mislearn
mispen10312173mispe_n
mister84728563mister_
misterm114314513misterm
misters93927503misters
nicer74618293ni_cer_
pastern94415063pastern
piecer105213083piecer_
piecers114112253piecers
pincer104019173pincer_
pincers113916503pincers
piscary1437423piscary
pisher114317753pisher_
pishers123815753pishers
pisser84416383pisser_
pissers95014753pissers
postern93615603postern
ricer74726613ri_cer_
ricers84120993ri_cers
risen54621883ris_e_n
riser55431053ris_er_
risers64624783ris_ers
risker105414493risker_
riskers114011993riskers
scorn75817443__scorn
secern81010223_secern
silvern10347133silvern
sincere9310553sincere
sister64421583sister_
sisters73721573sisters
stern55319123__stern
visceral1344673visceral
western102911093western
wincer115018193wincer_
wincers123415363wincers
wiser85522803wis_er_
wisher123617063wisher_
wishers133215213wishers
wivern12409283wi_vern
yestern10338633yestern
zithern19447023zithern

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272267.00019146.7
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.24924650.4
 
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.