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

182 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
sinister83858(None) 
minister10410361minister
banister10199972banister
canister101710852canister
filister1137402filister
finisher1436302finisher
ganister9178992ganister
insister888782_insister
ministers1139612ministers
minster93914322min_ster
pinaster1037112pinaster
sinisterly1352652sinisterly
sinter63625922sin__ter
sister64421582s__ister
snifter10349622s_nifter
songster935782songster
spinster1036682spin_ster
administer1343273administer
assister836753assister
banisher13169183banisher
banisters11189473banisters
bannister1155373bannister
bimester1236163bimester
bister84922763__bister
blister94415313_blister
canistel10187253canistel
canisters112310183canisters
cannister1155723cannister
cloister1037093cloister
demister11310223demister
diaster82813313di_aster
diester83013683di_ester
digester10258423digester
disaster949943disaster
disinter9310673disinter
enlister847803enlister
fibster12146533fi_bster
filisters1236993filisters
fillister1244423fillister
finises10312903finis_es
finished1536483finished
finishers1545353finishers
finishes1438983finishes
finite9316823fini_te_
finites10315923fini_tes
gangster10215773gangster
ganisters10248313ganisters
gannister1054173gannister
glister84013343_glister
grister83915413_grister
heister103613623_heister
hinter94021303hin__ter
hipster12288783hi_pster
hoister103714203_hoister
honester1139713honester
igniter8147663igni_ter
inciter93113773_inciter
indicter1148143_indicter
inditer83514233_inditer
infester11239433_infester
insider849733_insider
insisted998673_insisted
insisters997643_insisters
instar6310013_in_star
instep838193_in_step
inter55028493_in__ter
inviter104112313_inviter
keister113011573_keister
kiester11329973ki_ester
klister113410643_klister
knitter11348133_knitter
lamister1037653lamister
leister73212753_leister
limiter92710853limi_ter
linier64423793lini__er
linter64625343lin__ter
lioniser845583lionis_er
lister64527253__lister
magister1136283magister
meister93114163_meister
minished1437873minished
minishes13310583minishes
ministered1344963ministered
ministry1385793ministry
miniver1238393mini_ver
minsters103813913min_sters
minter84425103min__ter
minuter93510403min_uter
misinter1038833misinter
mister84728563__mister
moister94015373_moister
monster93214593mon_ster
munster93710523mun_ster
nester64124183__nester
niter55028973__ni_ter
penster92811953pen_ster
piaster93012883pi_aster
pilaster1038163pilaster
pinasters1136813pinasters
pinier84024693pini__er
pinite8321243pini_te_
pinites9319533pini_tes
plaister1068013plaister
punisher1335773punisher
punster92911103pun_ster
register939553register
resister8311653resister
rimester1037813rimester
rinser64317213rin_s_er
roister73516203_roister
scamster1235303scamster
scimiter1236143scimi_ter
scripter12137773scripter
seamster1037143seamster
seiser65318343s_eis_er
semester1038903semester
shifter132911073s_hifter
shinier104113143shini__er
shyster13116553s_hyster
sidestep1144243sidestep
sienite7312713sieni_te_
sienites8311913sieni_tes
sifter94516233s__ifter
sighter113412103si_ghter
signifier1345713signifier
silenter838873silenter
simitar936733simi_tar
sincerer1037203sincerer
singer74227313sin__ger
sinistral944683sinistral
sinker103620903sin__ker
sinner64320603sin__ner
sinters74024073sin__ters
sinuate7412153sinuate_
sinuated938403sinuated
sinuates8310953sinuates
sinuses73011593sinus_es
sissier73711363si_ssier
sisters73721573s__isters
sitter63323383s__itter
sizier1514813393sizi__er
skirter11338483s_kirter
skitter113810393s_kitter
slickster1543413slickster
slitter73615873s_litter
smiter83616413s_mi_ter
snicker133012673s_nicker
snider74413913s_ni_der
sniffer13318903s_niffer
snifters11318603s_nifters
snigger9328373s_nigger
sniper84413643s_ni_per
snipper113911323s_nipper
snorter74412653s_norter
songsters1046103songsters
sonsier7711743son_sier
spinier93715163spini__er
spinsters1136603spin_sters
spitter94015183s_pitter
splinter10329703splinter
splitter10348443splitter
sprinter103810813sprinter
squinter1747353squinter
squirter1746513squirter
stinter73614513s_tinter
stricter1039413stricter
subminister1552363subminister
subsister1145973subsister
suiter64121813s_ui_ter
swifter13318053s_wifter
swisher13369523s_wisher
tinier63622233tini__er
tinter63923643tin__ter
tipster9299053ti_pster
twister10308953_twister
uniter64619143_uni_ter
vanisher14167453vanisher
vinier93716743vini__er
visiter1038863visi_ter
waister103812383_waister
winier94522453wini__er
winter94222803win__ter

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.1561145455.1
2DLD Change Limit1461621827.50019488.3
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.73223110.6
 
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.