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

100 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
invital104695(None) 
incisal947372incisal
initial7311882in_itial
instal6712192in_stal
intimal9109942intimal
invite93715032invit_e
invited113612462invited
invitee103713542invitee
inviter104112312inviter
invites103915812invites
nonvital1147022nonvital
vital84819672__vital
anginal8310163anginal
animal85016253an_imal
antitax1447853antitax
anvil82712603anvi__l
capital112311523capital
chital114313883_chital
coital84117053_coital
cubital1137103cubital
devisal1136913devisal
digital937063digital
encinal949243encinal
finial92814183fin_i_al
finical1239693fin_ical
gavial10310083gavi_al
genital849793genital
gingival1342943gingival
ilial55317843i_li_al
incitable13310433incitable
incitant10810083incitant
incite83618733incit_e
incited103314623incited
inciter93113773inciter
incites93218483incites
incivil1244933incivil
incudal1045863incudal
indican1048243indican
indite73520323indit_e
indited93515023indited
inditer83514233inditer
indites83618983indites
inedita846793inedita_
inertial8411723inertial
inevitable1557643inevitable
inevitably1856193inevitably
infidel1146043infidel
infill938413infi_ll
inguinal945603inguinal
inia45024703in_i_a_
inimical1247313inimical
initials848103in_itials
inositol843983inositol
install779363in_stall
instals7611713in_stals
instar6310013in_star
instil61111383in_stil
instill789063instill
inthral10249463inthral
intima81910033intima_
intimae9109753intimae
intimas9119583intimas
intitle7610583intitle
intitule867423intitule
intravital1354823intravital
invar839513inv__ar
inviable1338523inviable
inviably1646893inviably
invirile1145813invirile
invitees11377903invitees
inviters11359643inviters
inviting1239733inviting
jovial1636543jovi_al
lanital7310913lanital
marital92314183marital
minimal114010603min_imal
minutial1046423minutial
natal53921493_n_atal
nidal65217103_n_idal
nival84915773_n_ival
nonviral1146743nonviral
notal55221353_n_otal
orbital936923orbital
pinitol936683pin_itol
pivotal1245433pivotal
recital9412163recital
revisal1038263revisal
revival1337033revival
silvical1345223silvical
somital939403somital
spital83813873_spital
uncial83715223unci_al
uncinal959963uncinal
unvocal1245233unvocal
vial76731093__vi_al
vinal85725813__vinal
viral86419593__viral
vita75828523__vita_
vitae84217633__vitae
vitals94514303__vitals

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271005.78323176.0
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.21928733.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.