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

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

99 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
preignition145443(None) 
preignitions1554001preignitions
reignition1144891_reignition
precognition1753882precognition
premonition1547352premonition
premunition1545572premunition
reignitions1244552_reignitions
ignition946533___ignition
precognitions1853593precognitions
precondition1755243precondition
predigestion1673823predigestion
premigration1755693premigration
premonitions1646853premonitions
premunitions1644983premunitions
prenotion1149173pre__notion
preposition15108583preposition
prevention1549173preven_tion
recognition1445203_recognition
reigniting1246373_reigniting
resignation1247473_resignation
assignation1244374assignation
cognition1247014__cognition
crenation11412924cre__nation
definition1445964_definition
designation1347484designation
ignitions1045804___ignitions
ignitron943204___ignitron
impregnation1754014impre_gnation
indignation1346534indignation
irrigation1147804irrig_ation
lenition8310084_le__nition
ordination1149414ordi_nation
origination1267094or_igination
pagination1348994pagi_nation
patination12312574pati_nation
perdition1249014p_e_rdition
perennation1348084perennation
personation1349484personation
petition10711754p_e__tition
pinnation1138014p__innation
precaution1447244pre_caution
precipitin1655864precipiti_n
precision13410054pre__cision
precognitive2052754precognitive
preconditions1854894preconditions
preconviction2253704preconviction
predation12313464pre__dation
predication16412434predication
prediction15410304pre_diction
predigestions1773284predigestions
predilection1754104predilection
preelection15136484preelection
preemption16105254pre_emption
prefiguration1953454prefiguration
prefixion2144114pre__fixion
prehension1546314prehen_sion
preinduction1753784preinduction
preinvasion1652464preinvasion
preinviting1744364preinviting
prelection141511294pre_lection
prelibation15128664prelibation
prenotions1248294pre__notions
preoption1348084pre__option
preparation1549274preparation
preportion1448874pre_portion
prepositions16108304prepositions
prescription18145344prescription
presentation1448994presentation
presignified1952444presignified
presignifies1852704presignifies
presumption17154174presumption
pretension1247534preten_sion
preunion1046894pre_un__ion
preuniting1347304pre_uniting
preventions1648534preven_tions
prevision1448004pre__vision
privation14311174pr_i_vation
profanation16186104profanation
prohibition1854264prohibition
pronation11415704pr__onation
proposition1588744proposition
protonation13510434protonation
punition1038374p___unition
recognitions1544854_recognitions
recondition1447124_recondition
redigestion1384154_redigestion
reedition1047834_re_edition
reignite947234_reignit__e
reignited1145684_reignit_ed
reignites1046934_reignit_es
remigration14228914_remigration
rendition1058934_re_ndition
repetition1278234_repetition
reposition121010144_reposition
resignations1346884_resignations
retention91611484_reten_tion
ruination9311274_rui_nation
trepanation1345484trepanation
urination9312174ur_i_nation

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819999.20316170.7
3Display Results99990.0462152.2
 (SQL Overall)178691999.68518450.3
 
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.