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

384 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
sincere931055(None) 
sincerer1037201sincerer
inhere9313712_inhere
insincere1143672insincere
mincer104017362mincer_
mincers113714842mincers
pincer104019172pincer_
pincers113916502pincers
since75024172sinc__e
sincerely1443462sincerely
sincerest1147872sincerest
sinecure1044322sinecure
singer74227302singer_
singers83824692singers
sinker103620902sinker_
sinkers113618542sinkers
sinner64320592sinner_
sinners74019012sinners
sinter63625922sinter_
sintered92213902sintered
sinters74024072sinters
wincer115018192wincer_
wincers123415362wincers
binder94422873binder_
binders103920743binders
bindery13459823bindery
biner75930693bin_er_
biners85023633bin_ers
binger94923443binger_
bingers104519983bingers
cancer104220923cancer_
cancered132411543cancered
cancers114018583cancers
cere66741473___cere
cicero1048503ci_cero
cincture1245583cincture
cinder94119123cinder_
cindered1239793cindered
cinders104617753cinders
cindery13429183cindery
coinhere1337133coinhere
concede12310083concede
concern113011963concern
concert113325223concert
dancer94817613dancer_
dancers103413093dancers
dicer85426423di_cer_
dicers94720743di_cers
diner65632903din_er_
dinero75612643din_ero
diners75525953din_ers
dinger85323663dinger_
dingers94321373dingers
dinner74217153dinner_
dinners83915433dinners
diocese1036853diocese
discern1038493discern
encore8314773_encore
fencer114613533fencer_
fencers123810623fencers
fiacre1137623fiac_re
fiancee1238953fiance_e
finder104020233finder_
finders113717873finders
finer85431563fin_er_
finery124512883fin_ery
finger104920323finger_
fingered13128323fingered
fingerer12127213fingerer
fingers113418423fingers
ginger84920023ginger_
gingered11127733gingered
gingers94118633gingers
gingery12368893gingery
ginner73915813ginner_
ginners84314213ginners
hinder104120063hinder_
hindered1339453hindered
hinderer1238273hinderer
hinders113718503hinders
hinger104723313hinger_
hingers113420193hingers
hinter94021303hinter_
hinters103719573hinters
incage93513623_incage
incase83615283_incase
incense92410303_incense
incent83320723_incent
incept102712753_incept
incest82918743_incest
incher114114023_incher_
inchers123912523_inchers
incise83515323_incise
incite83618723_incite
income10712093_income
incur72212253_incur_
incurs83012273_incurs
incurve1236633_incurve
incuse83513573_incuse
indene73215373_indene
inert53234373_in_ert
infare9313083_infare
infer84215033_infer_
infers93615443_infers
inhered11313163_inhered
inheres10315173_inheres
injure133410863_injure
inker94421093_inker_
inkers104018833_inkers
inner54920623_inner_
inners63919343_inners
innerve1056733_innerve
insert64325253_insert
insure63416603_insure
inter55028493_inter_
intern64016543_intern
interne73218143_interne
inters64328043_inters
inure54119053_in_ure
inverse10249643_inverse
invert94120083_invert
jinker174013543jinker_
jinkers183511813jinkers
jinnee13411573jinne_e
kinder113716843kinder_
lancer84319973lancer_
lancers93616643lancers
liner55938913lin_er_
liners65428843lin_ers
linger75225993linger_
lingered10129633lingered
lingerer9118293lingerer
lingerie959183lingerie
lingers84223293lingers
linier64423783linier_
linker104321463linker_
linkers114317703linkers
linter64625333linter_
linters73822613linters
mince95325233minc__e
minced114114903mince_d
minces104420803mince_s
mincier113512453mincier_
minder94822503minder_
minders103720113minders
miner76933543min_er_
miners84126633min_ers
minter84425103minter_
minters93822463minters
miocene1147913miocene
nicer74618293ni_cer_
noncore9411953noncore
piecer105213083piecer_
piecers114112253piecers
pincher143812703pincher_
pinchers153510613pinchers
pinder94523453pinder_
pinders103720473pinders
pinene82915643pin_ene
pinery115214283pin_ery
pinger94324083pinger_
pingers104020733pingers
pinier84024693pinier_
pinker125322443pinker_
pinkers134118603pinkers
pinkeye16326493pinkeye
pinner84521493pinner_
pinners93518593pinners
ricer74726613ri_cer_
ricers84120993ri_cers
ringer74526053ringer_
ringers83922943ringers
rinser64317213rinser_
rinsers73815743rinsers
riviere1036373riviere
sander74828533sander_
sanders84025943sanders
saner54334323san_er_
sanger74524563sanger_
sangers84421943sangers
santera7311303santera
santero7311133santero
saucer84314103saucer_
saucers93712133saucers
scare75334463s__care
scene77220573s__cene
score75526733s__core
scree720031703s__cree
secede93311993s_ecede
secern81010223s_ecern
secure8513533s_ecure
seiner64622483sein_er_
seiners74219273sein_ers
sender73824413sender_
senders83022353senders
sere46153473s___ere
severe94016083s_evere
shiner93820873shin_er_
shiners104015943shin_ers
shinier104113143shinier_
shinnery14305663shinnery
siamese936503siamese
sicced11489653sicce_d
sice65545593si_c__e
sices75637273si_ce_s
sickee124622223si_ckee
sicker124023903sicker_
sickie123715743si_ckie
sickle124418323si_ckle
sidler74716963sidler_
sidlers83414223sidlers
siege66718443si__ege
sieve84918843si__eve
sievert10613293sievert
sifter94516233sifter_
sifters103714783sifters
sigher103813703sigher_
sighers113712173sighers
signee73617233signe_e
signer74015623signer_
signers84714423signers
signore8329093signore
siker95326033si_ker_
silencer1036293silencer_
silencers1145283silencers
siller64026053siller_
sillers73822093sillers
silver93815813silver_
silvered12237563silvered
silverer11216733silverer
silvern10347133silvern
silvers104714033silvers
silvery13328093silvery
simmer104115353simmer_
simmered1336863simmered
simmers113314613simmers
simper103616293simper_
simpered1338253simpered
simperer1237173simperer
simpers113014113simpers
sincerity1445143sincerity
sine46560623sin___e
sinecures1144533sinecures
sines55954823sin_e_s
sinew84718923sin_e_w
sinewed1137053sin_ewed
sinews94210623sin_ews
sinewy12667513sin_ewy
singe65731133sin__ge
singed85422293singe_d
singes74326853singe_s
single74520603sin_gle
sinicize1947333sinicize
sinkage1287263sinkage
sinless73014213sinless
sinned73818413sinne_d
sinopie948763sinopie
sinsyne1043303sinsyne
sinuate7412153sinuate
sipper103920983sipper_
sippers113117743sippers
sire46150413si___re
siree55238813si_re_e
sirree64017333sirre_e
sister64421583sister_
sistered92612803sistered
sisters73721573sisters
sitter63323383sitter_
sitters74221543sitters
siver85728613si_ver_
sivers95324153si_vers
sizer145521813si_zer_
sizers155215813si_zers
sizier1514813393sizier_
skinker10319443skinker_
skinkers11298173skinkers
skinner11348093skinner_
skinners12347283skinners
slicer84117603slicer_
slicers94114923slicers
slinger83413823slinger_
slingers93712673slingers
snare54429983s_n_are
sneer54919953s_neer_
sneered83113973s_neered
sneerer73512313s_neerer
sneers64016173s_neers
sneery93610413s_neery
sneeze15318523s_neeze
snicker133012673snicker_
snickered16115343snickered
snickerer15134563snickerer
snickers143010963snickers
snickery17295543snickery
snider74413913snider_
sniper84413643sniper_
snipers93311763snipers
snore55424953s_n_ore
soccer1038543soccer_
soccers1138393soccers
sonder73623523sonder_
sonders83820713sonders
sorcerer1036433sorcerer
sorcery1237023sorcery
spacer104917793spacer_
spacers113813873spacers
spectre11297773spectre
spencer113610973spencer_
spencers12269193spencers
sphere113313653s_phere
spicer104719313spicer_
spicers113815553spicers
spicery14499013spicery
spinier93715163spinier_
spinner93912263spinner_
spinneret1146193spinneret
spinners103810863spinners
spinnery13416583spinnery
stere55328543s__tere
stinger84314683stinger_
stingers94012733stingers
stinker113313313stinker_
stinkers123111123stinkers
stinter73614513stinter_
stinters83312743stinters
subsere9311443subsere
sucre75019103s_uc_re
sunder74019823sunder_
sundered10312153sundered
sunderer9310523sunderer
sunders84120053sunders
swinger113812563swinger_
swingers123710423swingers
sycee105018623s_yce_e
syncarp1444533syncarp
synced12266963synce_d
synchro1544533synchro
syncope1445383syncope
tincture1044673tincture
tinder73821803tinder_
tinders84219173tinders
tindery11389353tindery
tinier63622233tinier_
tinker103619923tinker_
tinkered1387683tinkered
tinkerer1286803tinkerer
tinkers113517143tinkers
tinner64119953tinner_
tinners73717303tinners
tinter63923643tinter_
tinters74221103tinters
tinware1038593tinware
vinery124912593vin_ery
vinier93716743vinier_
viscera1235083viscera
wince105220883winc__e
winced124415343wince_d
winces114819113wince_s
wincey144110383wince_y
winceys15395523winceys
wincher153410643wincher_
winchers16319223winchers
winder104025263winder_
winders113721263winders
winery125014273win_ery
winger104125433winger_
wingers113921473wingers
winier94522453winier_
winker134220293winker_
winkers143517113winkers
winner94219923winner_
winners104316903winners
winter94222803winter_
wintered122111573wintered
winterer112110443winterer
winters103720473winters
wintery13399743wintery
yince105214253yinc__e
zincate1838533zincate
zinced18419413zince_d
zincite1837233zincite
zingare1737133zingare
zinger163816693zinger_
zingers173514843zingers

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.1431249587.4
2DLD Change Limit1340273846.73319906.0
3Display Results3843840.1402742.9
 (SQL Overall)1786913847.01625469.1
 
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.