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

143 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
nimious93766(None) 
simious939801simious
bilious9310932bilious
eximious1743872eximious
impious1137062_impious
nimbus10377282nim_bus
nimrods1044282nimrods
niobous936332niobous
nitrous73512482nitrous
niveous1037192niveous
noxious1446562noxious
numinous1046292numinous
osmious936002osmious
rimous8311912rim_ous
timeous938402timeous
vicious1239492vicious
amicus103810003_amicus
animis84615943animi__s
animisms12328393animisms
animists103010633animists
animus84211613anim__us
anxious1437283anxious
awmous1157713awm_ous
bijous1548043bi_jous
bimanous1245693bimanous
bimboes13498733bimboes
bimbos124610523bimbo_s
camions113916133camions
carious93320283carious
cimices13279803cimices
cirrous93111063cirrous
citrous93112993citrous
comous10816503com_ous
copious11311963copious
criminous1375323criminous
curious93813563curious
cymous1388403cym_ous
daimios1035753daimio_s
devious1138523devious
diecious1146873diecious
dimerous1139323dimerous
dimout9414243dim_out
dimouts1037893dim_outs
dioicous1145133dioicous
dubious1036893dubious
envious1037223envious
famous11412393fam_ous
fibrous1237593fibrous
folious103710733folious
furious103110633furious
gibbous1265333gibbous
gummous1236263gummous
hideous1168433hideous
idioms956413_idioms
idiots768643_idiots
imides94515343_imides
imids86015143_imi_ds
imines84918353_imines
inions64417003_inions
insidious1044183insidious
invidious1343433invidious
iodous7311503_iodous
laminous1037953laminous
limbos104712143limbo_s
limbus105710383lim_bus
limites92915453limites
limits82514143limi_ts
limos75320813lim_o_s
limulus935083limulus
luminous1037113luminous
meous76120063__meous
miaous8511693mi_aous
milieus939803milieus
mimeos104511543mimeo_s
mimics1289363mimi_cs
minibus1136343minibus
minions93314623minions
minus75223933__minus
nairus639143n_airus
nasions73112383nasions
nations74720563nations
nervous1037143nervous
nicols8810243ni_cols
nidus65913573n__idus
nihils937573nihi_ls
nilgaus844003nilgaus
nimiety1244633nimiety
nimrod934873nimro_d
nims66226883nim___s
ninons64913773ni_nons
nisus56014393n__isus
nitinols844413nitinols
nitons64614903ni_tons
nitros64214123nitro_s
nixies135313873nixi_es
nocuous946583nocuous
nodous7711333n_odous
nomisms11268743nomisms
nomos75919743nom_o_s
notions74014483notions
nous46136983n___ous
nubilous1044843nubilous
numerous1047843numerous
obvious1244823obvious
odious749933_odious
ominous949033ominous
osmous8138183osm_ous
piceous11310693piceous
pileous9510523pileous
pilous84717753pi_lous
pinions93413603pinions
pious74621273__pious
pistous92714383pistous
piteous9310683piteous
pompous1338063pompous
ramous8417113ram_ous
ricinus9408123ricinus
riotous739863riotous
rubious938283rubious
sanious7514103sanious
serious73616283serious
simians959203simians
similes92915233similes
simioid1047993simioid
simooms1135573simooms
simoons937943simoons
sinuous739063sinuous
tedious838443tedious
timeout948593timeout
timeouts1044773timeouts
timings10279303timings
timorous1047433timorous
untimeous1144443untimeous
various103113103various
villous102810023villous
vimineous1443083vimineous
vinous93914173vi_nous
virions1039873virions
viscous1238833viscous
visions10311023visions
vomitous13215803vomitous
vomitus12215743vomitus
zincous1837053zincous

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 Limit1340271437.50017870.3
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.70223200.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.