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

92 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
incisal94737(None) 
encinal949242encinal
incise83515332incis_e
incised102911582incised
incises93414892incises
incisor955322incisor
incivil1244932incivil
incudal1045862incudal
intimal9109942intimal
invital1046952invital
uncial83715222unci_al
uncinal959962uncinal
accusal11136003accusal
aecial84817313aeci_al
ancilla948603ancilla
anconal939423anconal
anginal8310163anginal
animal85016253an_imal
antisag838043antisag
biocidal1344943biocidal
decimal1238083decimal
devisal1136913devisal
duncical1345213duncical
encina8310443encina_
encinas938723encinas
facial113615633faci_al
fecial114714623feci_al
finial92814183fin_i_al
finical1239693fin_ical
gingival1342943gingival
ilial55317843i_li_al
incase83615283incas_e
incased103612393incased
incases93615973incases
incest82918743inces_t
incests92711383incests
inchmeal1543653inchmeal
incipit1158923incipit
incising11411093incising
incision1047603incision
incisive1346283incisive
incisors1095293incisors
incisory1353863incisory
incisure1044563incisure
incitable13310433incitable
incitant10810083incitant
incite83618733inci_te
incited103314623incited
inciter93113773inciter
incites93218483incites
inclasp1145303inclasp
incus73315053incus__
incuse83513573incus_e
incused102911173incused
incuses93514853incuses
indican1048243indican
indusial966643indusial
infidel1146043infidel
infill938413infi_ll
inguinal945603inguinal
inia45024703in_i_a_
inimical1247313inimical
initial7311883initial
insist6314513insis_t
insists739083insists
instal6712193in_stal
inthral10249463inthral
intima81910033intima_
intimae9109753intimae
intimas9119583intimas
intis55121643intis__
ischial1246423ischial
minimal114010603min_imal
mucosal11155843mucosal
nasal56217593_n_asal
nasial6413283_nasial
nidal65217103_n_idal
nival84915773_n_ival
piscinal1285843piscinal
principal1574453principal
racial83419243raci_al
recital9412163recital
recusal968673recusal
revisal1038263revisal
sisal54217733__sisal
social8813333soci_al
tincal83913363tinc__al
uncia75015163unci_a_
unciae83215313unci_ae
uncials92510523unci_als
uncivil1244793uncivil
vicinal12268543vicinal

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027926.85619548.9
3Display Results92920.0332787.9
 (SQL Overall)178691927.04525364.2
 
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.