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

118 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
fictive153702(None) 
fictile1238021fictile
active11313742_active
festive1339772festive
fiction122010732fiction
fictively2044602fictively
fixative2145082fixative
fricative1746742fricative
furtive1337172furtive
actives12311523_actives
addictive1644563addictive
affective20135413affective
afflictive21102803afflictive
airtime948063airtime
amative12311733amative
archive154610483archive
bigtime1235753bigtime
bijective2343913bijective
bioactive1644133bioactive
biotite9311033biotite
captive1438973captive
chive135117623__chive
coactive1598623coactive
costive12312843costive
dative10311813_dative
deceive1337813deceive
defective1848003defective
dickie133913113dicki_e
dictate10311663dictate
dictier103411863dictier
diction102313053diction
dilative1239523dilative
dilutive1255373dilutive
directive1557773directive
ductile1048483ductile
eductive1476863eductive
effective2076193effective
ejective2037153ejective
elative10312453elative
elective13311003elective
emotive1239193emotive
enactive1338513enactive
erective13311833erective
facetiae1346213facetiae
faciae112913413fac_iae
facile112514883fac_ile
faction122613333faction
factitive1745033factitive
facture12108933facture
fertile10311733fertile
fice95737113fic___e
fiche134616743fic__he
ficin103516723fic_i_n
ficins113513983fic_ins
fickle153912973fic_kle
fictions132410743fictions
fifties132111083fifties
finite9316823fi_nite
finlike14279063finlike
fissile10269653fissile
fistic11812573fisti_c
fisting113818123fisting
fitchee152710783fitchee
fitting113516563fitting
five107629743f___ive
fixatives2243353fixatives
fixture1734963fixture
footie94718143footi_e
forgive1436193forgive
fricatives1844683fricatives
friction1347913friction
fugitive1544173fugitive
futile93914953f_utile
hickie153812473hicki_e
ictic9311803_icti_c
inactive1348203inactive
infective17108973infective
inflictive18104633inflictive
intime81014273_intime
intine61021983_intine
kiltie103210963kilti_e
ligative1258803ligative
locative1338683locative
misgive13339033misgive
mislive122812693mislive
missive122413143missive
mistime11312613mistime
motive113112143_motive
native9613013_native
nicoise937923nicoise
nicotine1058473nicotine
nictate9310223nictate
octave11157343_octave
olfactive1743463olfactive
orective1339353orective
pectize20259913pectize
picrite111911313picrite
picture1158613picture
reactive13310473reactive
receive1239733receive
refective1749113refective
restive10315933restive
riptide1036883riptide
scrive115414943_scrive
sectile9311973sectile
siccative1645103siccative
sickie123715743sicki_e
stative102612933stative
tactile9310613tactile
tectite9310583tectite
tittie63213153titti_e
tractive13310043tractive
unitive10310563unitive
victim1337693victi_m
victims1436003victims
visive1257873vi_sive
vocative1637913vocative
votive12348933_votive

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.453394461.4
2DLD Change Limit1340271187.45317983.0
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.95222471.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.