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

123 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
victims143600(None) 
victim1337691victim_
dictums1235552dictums
vichies15310622vichies
victimise1674132victimise
victors123311182victors
actins86321103_actins
airtime948063airtime
airtimes1037503airtimes
arctics1138953arctics
bigtime1235753bigtime
biotics113812173biotics
biotins93114453biotins
cities84524853ci_ties
deictics1345563deictics
diatoms1039073diatoms
dickies143416343dickies
dictier103411863dictier
dictiest113212783dictiest
diction102313053diction
dictions111812673dictions
dictum1136863dictum_
dirties83119383dirties
distils83015803distils
ditties83116983ditties
evictees1344583evictees
evicting1437483evicting
eviction13228683eviction
evictions14228623evictions
evictors13276853evictors
evicts11368553evict__s
ficins113513983fic_ins
fictile1238023fictile
fiction122010733fiction
fictions132410743fictions
fictive1537023fictive
fifties132111083fifties
hickies163614743hickies
ictic9311803_icti_c
ictus7249703_ict_us
intima81910033_intima
intimas9119583_intimas
intime81014273_intime
intis55121643_inti_s
items7499613_i_tems
kilims1277903ki_lims
kilties113014143kilties
kitties113213623kitties
lactams1136953lactams
lectins92515003lectins
lichis115212593lichi_s
lictors93212603lictors
minims104514813mi_nims
miotics112710653miotics
misaims11310113misaims
mistime11312613mistime
mistimes12612613mistimes
mitis75425993mi_ti_s
mittimus1243023mittimus
niceties10310863niceties
nicotins1058173nicotins
nifties102612503nifties
pectins112315233pectins
picnics13297343picnics
pieties9419223pieties
pietism1139113pietism
pietisms1247463pietisms
pistils93314303pistils
pities83828083pi_ties
rectums11338523rectums
ricins83618703ric_ins
rictus8379193rict_us
santims9312603santims
scrims104615933_scrims
shittims1344423shittims
sickies133717503sickies
sitcoms1145533sitcoms
sixties14310973sixties
tactics1149323tactics
tectums11306423tectums
tictacs1145793tictacs
tictocs1145903tictocs
titis56023813ti_ti_s
titties73617363titties
vacuums1443403vacuums
vectors123212593vectors
viatic11311453viati_c
viatica1245863viatica
viaticums1642173viaticums
viators102712023viators
vibrios1235803vibrios
vicars11712263vic_ars
vices105725533vic__es
vicing124014243vic_ing
vicious1239493vicious
victimised1872793victimised
victimises1774093victimises
victimize2544083victimize
victimizes2664033victimizes
victimless1751813victimless
victor113210673vict_or
victorias1446523victorias
victories1448923victories
victory15326983victory
victress1344523victress
victual1246253victual
victuals1344773victuals
vicunas1285613vicunas
vigias104110893vi_gias
vigils104210193vi_gils
vims95423313v___ims
violins10311453violins
virgins1137863virgins
viroids1137923viroids
virtues10338023virtues
virtus94310143virt_us
visits9311423vi_sits
vistas94513273vist_as
vitals94514303vi_tals
vitrics12198553vitrics
vittles103211113vittles
vizirs18306713vi_zirs
zitis145815583zi_ti_s

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.393454684.5
2DLD Change Limit1340271235.73323378.2
3Display Results1231230.0631952.4
 (SQL Overall)1786911236.18928872.4
 
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.