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

102 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
igneous83577(None) 
ligneous945231ligneous
aeneous739892aeneous
idoneous944572idoneous
aeneus61111143aene_us
agamous1037943agamous
angelus8418463angelus
aqueous1636053aqueous
arenous7314183arenous
bigamous1385503bigamous
bigness1038193bigne_ss
biogenous1244853biogenous
caseous9312513caseous
cineols9128853cineols
citreous1056853citreous
congous103615083congous
corneous10310033corneous
digamous1296063digamous
duteous838453duteous
epigenous1245353epigenous
epigeous1146533epig_eous
fungous11367433fungous
gaseous839503gaseous
generous939773generous
genius74512923_genius
genoas74013623_genoas
genoms94412483_genoms
genus65319833_g_enus
gibbous1265333gibbous
ginzoes1735433ginzoes
gneiss765953_gneiss
gnus56518003_gn__us
hideous1168433hideous
hugeous1137133hugeous
icterus936073icterus
igloos738033ig_loos
iglus6609933ig__lus
ignites81310583ignites
ignitors9135513ignitors
ignore7269063ign_ore
ignores8269003ignores
ileus54616893i_le_us
impetus1144893impetus
impious1137063impious
incogs937903i_ncogs
incus73315053i_n_cus
indols74714203i_ndols
indows104210793i_ndows
inerts64517023i_nerts
infos84311673i_nfo_s
ingenious1046013ingenious
ingenue847133ingenue
ingenues947103ingenues
ingenuous1043833ingenuous
ingests83210983ingests
ingots7912063i_ngots
ingroup1044333ingroup
ingroups1143483ingroups
inions64417003i_nions
inners63919353inne_rs
inpour837063i_npour
inpours936423i_npours
insoul638463i_nsoul
insouls737213i_nsouls
iodous7311503i_odous
isogenous1044603isogenous
luteous739273luteous
meous76120063__meous
mignons1037863mign_ons
negus64513563__negus
neons55818683__neons
nevus84611393__nevus
nexus124710663__nexus
niveous1037193niveous
nous46136983__n_ous
onerous7312973_onerous
osseous736053osseous
piceous11310693piceous
pigeons1039183pig_eons
pignus937953pign__us
pileous9510523pileous
piteous9310683piteous
righteous1345073righteous
rigorous947373rigorous
sanious7514103sanious
signees83510803signe_es
signers84714443signe_rs
signets83311503signe_ts
signiors944923signiors
signors83410913sign_ors
sinuous739063sinuous
tenuous738483tenuous
timeous938403timeous
uveous936603_uveous
venous93713193ven_ous
vignerons1343163vignerons
vigorous1245763vigorous
vimineous1443083vimineous
vinous93914173vin_ous
vitreous1145843vitreous
wigeons1136983wig_eons
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.406440125.6
2DLD Change Limit1340271026.54620474.6
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.