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

196 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
igniters912622(None) 
igniter8147661igniter_
ignites81310571ignite_s
ignitors9135501ignitors
gaiters83516532_gaiters
goiters84014432_goiters
ignite71410582ignite__
ignited9137622ignite_d
ignitor8125262ignitor_
ignorers9215232ignorers
inciters103210652inciters
inditers93311042inditers
inters64328042i_n_ters
inviters11359632inviters
ionizers17257712ionizers
lignites9129602lignite_s
niters64624202__niters
uniters73814172_uniters
aginners954623aginners
agnates82813183agnate_s
agnizes17328843agnize_s
arbiters1038853arbiters
awaiters1146643awaiters
baiters94619303_baiters
banisters11189473banisters
banters94623113ban_ters
biters83925233__biters
bruiters10329133bruiters
bunters94717113bun_ters
canisters112310183canisters
canters94827723can_ters
centers94420593cen_ters
citers85022973__citers
cognizers2164423cognizers
cointers103616403cointers
conifers133611703conifers
deniers84515183deni_ers
digesters11257873digesters
dignitary1442463dignitary
dignities1149593dignities
disinters1039703disinters
disuniters11104723disuniters
dunites8313593dunite_s
enters64425643_en_ters
exciters1736323exciters
fainters11349693fainters
figeaters1345743figeaters
fighters15269393fig_hters
finites10315923finite_s
fruiters11328173fruiters
gainers84214593_gainers
gaiter73819503_gaiter_
ganisters10248313ganisters
garters84218223_garters
gasters85624283_gasters
gaters74728633_g_aters
genitors937423genitors
getters84216093_getters
gibers95114663_g_ibers
gingers94118643gin_gers
ginners84314223gin_ners
gites65630183_g_ite_s
givers104817713_g_ivers
gliders94811843_gliders
glisters93912603_glisters
glitters93710543_glitters
gnawers11356383_gnawers
goiter74116203_goiter_
goitres8389563_goitres
graters85419733_graters
grifters12389233_grifters
gripers104011463_gripers
gristers94013403_gristers
gritters94210633_gritters
guiders94111103_guiders
guitars8116853_guitars
gunites8313123gunite_s
gutters83715503_gutters
hinters103719573hin_ters
hunters103915723hun_ters
ichnites1345743ichnite_s
ignatias944903ignatias
ignifies1277563ignifies
igniting1037363igniting
ignition946533ignition
ignitions1045803ignitions
ignitron943203ignitron
ignitrons1042993ignitrons
ignorer8276103ignorer_
ignores8269003ignore_s
illites72415013illite_s
imbibers1433493imbibers
imbitters13274503imbitters
imputers1235813imputers
inchers123912523i_nchers
inciter93113773inciter_
incites93218483incite_s
indicters1236733indicters
inditer83514233inditer_
indites83618983indite_s
infers93615443i_n_fers
ingates82716893ingate_s
ingathers1344433ingathers
inkers104018833i_n_kers
inliers73110743i_nliers
inners63919353i_n_ners
insiders947753insiders
insisters997643insisters
instars7411113i_nstars
insteps936573i_nsteps
inter55028493i_n_ter_
intern64016543i_n_tern
interns73116763i_n_terns
invitees11377903invitees
inviter104112313inviter_
invites103915813invite_s
iodizers18316123iodizers
iolites73819483iolite_s
ionises72916433ionise_s
ionizer162310123ionizer_
ionizes162813343ionize_s
ionomers1038503ionomers
janitors1536853janitors
jointers15289323jointers
junipers1733923junipers
kiters105218583__kiters
knifers14537083_knifers
knitters12336623_knitters
lenites7818443lenite_s
lighters123111383lig_hters
lignite81310303lignite__
limiters10249323limiters
linters73822623lin_ters
lionisers944173lionisers
lionizers1844243lionizers
liters65429873__liters
loiters74116613_loiters
ministers1139613ministers
minivers1337473minivers
minsters103813913minsters
minters93822463min_ters
misinters1138163misinters
miters84328773__miters
monikers1437413monikers
monitors10310813monitors
monsters103314533monsters
munsters104010543munsters
niter55028973__niter_
nitery94412173__nitery
nites55736343__nite_s
nitres65519333__nitres
noters64020993__noters
orbiters1036593orbiters
painters103013023painters
paniers94717333pani_ers
pensters103012123pensters
pinites9319533pinite_s
plaiters103512633plaiters
pointers103013723pointers
printers103214903printers
punsters103310583punsters
punters93617033pun_ters
ranters73323643ran_ters
reciters102613113reciters
reignites1046933reignite_s
reinters82614773reinters
renters74224813ren_ters
rentiers83311763rentiers
reuniters936423reuniters
righters122610703rig_hters
sienites8311913sienite_s
sighters122510593sig_hters
signalers1044573signalers
signers84714433sign__ers
signifiers1444183signifiers
signiors944913signi_ors
sinters74024073sin_ters
smiters93414363_smiters
snifters11318603_snifters
snipers93311763_snipers
stinters83312743stinters
suiters73618873_suiters
tenters73921103ten_ters
tinters74221103tin_ters
titers64526403__titers
uniter64619143_uniter_
unites65024853_unite_s
unmiters1037073unmiters
venters103717723ven_ters
vignetters1442443vignetters
visiters1137403visiters
vomiters1337203vomiters
waiters104218623_waiters
wanters104420093wan_ters
winters103720473win_ters
writers105513493_writers

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621969.03316180.9
3Display Results1961960.0762578.9
 (SQL Overall)1786911969.26219292.9
 
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.