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 “examiner” 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
examiner1714546(None) 
examine161510031examine_
examined18135861examined
examinee17156581examinee
examiners18124431examiners
examines17128791examines
enamine91214312enamine_
enamines101112132enamines
etamine91313072etamine_
etamines101611812etamines
examinees18123782examinees
hexamine2046872hexamine_
hexamines2146202hexamines
aliner65621983__aliner
amine75835383__amine_
amines84727983__amines
beamier113411943beami_er
damner95213433_dam_ner
detainer92910793deta_iner
diamine10311983diamine_
diamines11311643diamines
drainer83012843dra_iner
earner63617223e_a_rner
easier64218463e_asi_er
elapine9310673elapine_
elmier839813e_lmi_er
eloiner7149183e_loiner
enameler1045883enameler
enjoiner15225653enjoiner
ermine8416923e_rmine_
ermined10410603e_rmined
ermines9416673e_rmines
estaminet1149693estaminet
etamin81311853etamin__
etamins91511833etamin_s
exacter1637403exa_cter
exalter1437563exa_lter
examen1538283exam__en
examens1637193examen_s
examinant1844603examinant
examining1945143examining
example1844283example_
exampled2043353exampled
examples1944313examples
excimer1834963ex_cimer
exciter1637753ex_citer
exiler134712183ex__iler
exine125518493ex__ine_
exines135715803ex__ines
expirer1635993ex_pirer
explainer1844243explainer
eyeliner1174893eyeliner
fainer94717243_fa_iner
famine114318193_famine_
famines123216263_famines
flamier123112143flami_er
flamines13311643flamines
foamier12339003foami_er
gainer74117493_ga_iner
gamier93617933_gami_er
gamine94620153_gamine_
gamines103618463_gamines
grainer83714063gra_iner
hexameter2144853hexameter
imaginer1144303imaginer
ketamine14157053ketamine_
ketamines15177033ketamines
laminar93810283_laminar
loamier9349163loami_er
mariner93315993_mariner
melamine12310303melamine_
melamines1339763melamines
miner76933543___miner
oxazine2354773oxazine_
oxazines2434073oxazines
plainer93811983pla_iner
recamier1237603recami_er
reexamine1844493reexamine_
reexamined2052893reexamined
reexamines1953873reexamines
regainer9249353rega_iner
retainer82913813reta_iner
seamier93114633seami_er
stainer73614923sta_iner
trainer73316793tra_iner
unexamined2042573unexamined
vainer93714573_va_iner

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 Filter1786911461620.420425454.8
2DLD Change Limit146162876.90621164.5
3Display Results87870.0332636.4
 (SQL Overall)178691877.35924282.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.