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 “ignition” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
ignition94653(None) 
ignitions1045801ignitions
ignitron943201ignitron
agnation9311722agnation
cognition1247012cognition
igniting1037362igniting
ignitor8125262ignit_or
ignitrons1042992ignitrons
inanition947292inanition
lenition8310082lenition
monition10311722monition
munition1038762munition
punition1038372punition
reignition1144892reignition
addition1096893addition
adnation9310783adnation
agnations10310033agnations
ambition1246563ambition
audition979173audition
cognation12310753cognation
cognitions1346043cognitions
coition9314313_coition
conation101420883conation
condition12411163condition
dentition1049633dentition
digestion1146573digestion
dignities1149593dignities
donation91513783donation
edition8310853_edition
egestion946863egestion
enation73419233_enation
fruition11106103fruition
function1337843function
gnathion1243443_gnathion
ideation9310493ideation
ignatia846133ignati_a
ignatias944913ignatias
ignified1386213ignified
ignifies1277563ignifies
ignite71410583ignit__e
ignited9137623ignit_ed
igniter8147673ignit_er
igniters9126233igniters
ignites81310583ignit_es
ignitible1243163ignitible
ignitors9135513ignitors
illation8311943illation
inaction1039623inaction
inanitions1046383inanitions
incision1047603incision
indiction1239813indiction
infixion1843683infixion
ingestion10137483ingestion
inion54620183i_n__ion
initial7311883i_nitial
intron64215023i_n_tron
intuition947623intuition
inunction1146893inunction
iodation9310383iodation
ionization19411273ionization
junction1736203junction
lenitions939473lenitions
ligation92313093lig_ation
lignitic1146393ligniti_c
lunation8311923lunation
mention9314373men_tion
migration12179703migration
monitions11310883monitions
munitions1138173munitions
nation64322803__nation
niton55418283__nit_on
notion64516583__notion
petition10711753petition
pinnation1138013pinnation
position10912193position
preignition1454433preignition
punitions1137923punitions
reignitions1244553reignitions
rendition1058933rendition
sanction1049533sanction
sedition939333sedition
tuition738823_tuition
unction9310663_unction
venation11513503venation
vendition1345693vendition
volition1179173volition
zonation171410723zonation

Search took 7 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.406440125.6
2DLD Change Limit146162876.34323043.0
3Display Results87870.0501740.0
 (SQL Overall)178691876.79926282.0
 
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.