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

140 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
violating133743(None) 
dilating102714902di_lating
etiolating1146972etiolating
iodating1038822_iodating
isolating1039742isolating
reviolating1556252reviolating
solating9315592_solating
variolating1544932variolating
vibrating1537472vibrating
violation1238442violation
violations1337962violations
violative1545112violative
vitiating1338402vitiating
ablating11311993_ablating
acylating1547563acylating
adulating1178713adulating
aviating12311013avi__ating
billeting1236633billeting
bloating113512813blo_ating
boating103721303_bo_ating
bolting104416763_bol_ting
borating113414503_borating
bromating1439173bromating
chelating1549353chelating
coating103525313_co_ating
collating12312763collating
deflating142610713deflating
delating103119603_delating
desolating1239463desolating
dictating1338883dictating
diluting10248983di_luting
disrating11714553disrating
doating93816863_do_ating
donating10311803_donating
elating83423083__elating
emulating1239873emulating
epilating12310963epilating
fellating1339243fellating
fileting1239303fi_leting
filiating1339243filiating
filleting1335843filleting
fixating1936183fi_xating
floating123111883flo_ating
foliating1339253_foliating
gelating103015733_gelating
gimleting1343863gimleting
gloating102611463glo_ating
hilting113316893hi_l_ting
ideating10311703_ideating
immolating1545053immolating
inflating13310443inflating
inlacing1158373_inlacing
inlaying1247893_inlaying
insolating1149153insolating
jilting153211743ji_l_ting
jolting153410913_jol_ting
kilting123213853ki_l_ting
librating1239053librating
ligating102212283li_gating
lilting83515383li_l_ting
liquating1946313liquating
locating11311503_locating
migrating13910533migrating
milting103619123mi_l_ting
misdating131010663misdating
miseating121215433miseating
mislaying1557913mislaying
mismating141211823mismating
misrating121014853misrating
moating104218153_mo_ating
molting103517173_mol_ting
nictating1237573nictating
nidating1039783ni_dating
nitrating10312673nitrating
notating92513343_notating
orating83520323__orating
ovulating1336953ovulating
oxalating1745803oxalating
ozonating1944323ozonating
phonating1537813phonating
pillaging1345553pillaging
pillaring1237643pillaring
piloting1139693pi_loting
pirating11314513pi_rating
plating103823073__plating
probating14311193probating
pronating12313763pronating
prorating12314283prorating
reflating132514713reflating
relating92725443_relating
replating122217403replating
reslating102516993reslating
rioting82716393rio__ting
rotating92614553_rotating
sibilating1346963sibilating
silting83320483si_l_ting
simulating1347613simulating
sinuating1039683sinuating
situating1038883situating
slating83724653__slating
solacing11310133_solacing
solvating1336443_solvating
spoliating1366963spoliating
sublating12310983sublating
tilting83417103ti_l_ting
titrating10310113titrating
toileting1036263toileting
ululating1036643ululating
vacating14310353v_acating
vacillating1744613vacillating
valeting1238843v_aleting
valuating1338643valuating
variating13310943variating
vaulting12227223vaul_ting
vialing113614163vi__aling
vialling1237223vial_ling
villain1038473villa_in_
villains1138003villa_ins
villainy1444873villa_iny
villatic1346223villati_c
violate10311553violat__e
violated1237883violat_ed
violater1137253violat_er
violaters1245963violaters
violates11311193violat_es
violator1146283violat_or
violators1246583violators
violin9311983viol__in_
violins10311453viol__ins
visaing11279333vi_sa_ing
visiting1238393vi_siting
volatile1146433v_olatile
voling103918023v_ol__ing
voluming1435043v_oluming
volutin1098103v_olutin_
volutins1188003v_olutins
vomiting1437733v_omiting
voting103916033v_o__ting
voyaging1632553v_oyaging
wilting113515913wi_l_ting

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411407.61019532.3
3Display Results1401400.0801750.0
 (SQL Overall)1786911408.14321944.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.