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

134 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
victim133769(None) 
victims1436001victims
dictum1136862dictum
ictic9311802_ictic
viatic11311452viatic
victor113210672victor
actin74922553_actin
airtime948063airtime
arctic10313513arctic
aviatic1239243aviatic
bigtime1235753bigtime
biotic103816613biotic
biotin83215833biotin
cacti9318643cacti_
deictic1237703deictic
diatom939453diatom
dickie133913113dickie
dicta84915633dict_a
dictier103411863dictier
diction102313053diction
dictums1235553dictums
dicty115116293dict_y
distil73616433distil
evict104417143evict__
evicted1337243evicted
evictee1248103evictee
evicting1437483evicting
eviction13228683eviction
evictor12346363evictor
evicts11368553evict_s
ficin103516723fic_in
fictile1238023fictile
fiction122010733fiction
fictive1537023fictive
fistic11812573fistic
gittin72910553gittin
hectic132311523hectic
hickie153812473hickie
ictus7249703_ictus
inti46626083_inti_
intima81910033_intima
intime81014273_intime
intis55121643_intis
item65620383_i_tem
kilim11711893ki_lim
kiltie103210963kiltie
lactam10310943lactam
lactic10713493lactic
lectin82515013lectin
lichi104412953lichi_
lichis115212593lichis
licit74327683lic_it
lictor83610863lictor
minim97321603mi_nim
miotic103715753miotic
misaim10311853misaim
mistime11312613mistime
mitis75425993mi_tis
nicotin948383nicotin
nitid61817833ni_tid
pectic122913873pectic
pectin102615533pectin
picnic123410263picnic
picric12309923picric
pietism1139113pietism
pistil83915073pistil
recti73619623recti_
rectum103411283rectum
ricin74620213ric_in
rictal83113183rictal
rictus8379193rictus
scrim95419743_scrim
shittim1245133shittim
sickie123715743sickie
sitcom1036903sitcom
tactic10612753tactic
tectum10328603tectum
tictac1036563tictac
tictoc1036003tictoc
titi47130623ti_ti_
titis56023813ti_tis
tittie63213153tittie
vacuum1334833vacuum
vatic10316423v_atic
vector113212063vector
viatica1245863viatica
viaticum1542733viaticum
viator93211833viator
vibrio1136223vibrio
vicar10513863vic_ar
vicars11712263vicars
vice95732853vic__e
viced115118183vic_ed
vices105725533vic_es
vichies15310623vichies
vichy1639043vic_hy
vicing124014243vicing
victimise1674133victimise
victimize2544083victimize
victoria1346323victoria
victors123311183victors
victory15326983victory
victual1246253victual
vicuna11115903vicuna
vigia94813273vi_gia
vigil94313003vi_gil
villi86517853villi_
vim87437023v___im
vinic10314973vi_nic
violin9311983violin
virgin1038083virgin
virid94116043vi_rid
viroid10411523viroid
virtu85314093virt_u
virtue9358673virtue
virtus94310143virtus
viscid1237473viscid
viscoid1337023viscoid
visit8320963vi_sit
visits9311423visits
vista85416603vist_a
vistas94513273vistas
vita75828523vi_t_a
vitae84217633vi_tae
vital84819673vi_tal
vitric112510113vitric
vitta85015173vi_tta
vittae93911003vittae
vittle94711753vittle
vivid125112313vi_vid
vizir17359393vi_zir
volti84915963volti_
ziti136022373zi_ti_
zitis145815583zi_tis

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 Filter1786911127160.766233278.1
2DLD Change Limit1127161346.45317467.2
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.26524596.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.