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

112 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
viatores1125768(None) 
viators102712021viator_s
aviators11169902aviator_s
viator93211832viator__
victories1448912victories
victors123311182victor_s
abators94413083abator_s
adores74420723__adores
atones65225773__atones
aviates10313063aviat__es
aviator10229663aviator__
aviatress1242433aviat_ress
avigators13177093avigator_s
biotopes1246963biotopes
bistorts10118813bistorts
bistres94017213bist_res
citators10310253citator_s
citoles9312553ci_toles
deviators1358533deviator_s
diaspores1266543diaspores
diastoles1047493diastoles
diatoms1039073diato_ms
diatrons939613diatrons
diazoles1836323diazoles
dilators93213193dilator_s
distomes11314163distomes
distorts91112353distorts
evictors13276853evictor_s
features11310333features
fiacres1237253fia_cres
filatures1245853filatures
fixtures1835283fixtures
galores82614323_galores
gators74115833_gator_s
hiatuses1135773hiatuses
histones11312803histones
histories12412473histories
ignores8269003_ignores
intones7816543_intones
intorts7310973_intorts
levatores12225733levatores
lictors93212593lictor_s
ligatures1044933ligatures
litotes7311183li_totes
litres65220393li_t_res
matres84522233_mat_res
matures9314303_matures
misatones1148933misatones
mitoses9312183mi_toses
mitres83922073mi_t_res
mixtures1735753mixtures
natures7311963_natures
nitres65519333ni_t_res
obviators1444843obviator_s
oratories9410643oratories
orators7313823orator_s
piastres10249303piastres
picadores1444363picadores
pictures1249343pictures
pinafores1444503pinafores
pintoes95117713pinto_es
pistoles102514723pistoles
quatorzes2743123quatorzes
quatres163411933quat_res
restores85222993restores
rotatores946473rotatores
satires72617573_satires
satoris7317253_satoris
skatoles1236143skatoles
stators73915583stator_s
statures83711113statures
stores65533663__stores
tiptoes939173tipto_es
titres64718933ti_t_res
tores55352673___tores
valors93413773v_alor_s
vamoses1239143v_amoses
vapored1336923v_apored
vaporer1236983v_aporer
vaporers1336243v_aporers
vapors113812693v_apor_s
vectored1435623vectored
vectors123212593vector_s
ventures11311493ventures
vestures11311043vestures
vetoers10359473v_etoers
vetoes92914083v_eto_es
vibrators14237253vibrator_s
victor113210673victor__
victoria1346313victoria
victorias1446523victorias
victory15326983victor_y
victress1344523vict_ress
vigors102911483vi_gor_s
vintages12118273vintages
vintners1134573vintners
violators1246583violator_s
violones1137383violones
viragoes1245233virago_es
vires84529683vi___res
viroses10310533vi_roses
virtues10338023virt_ues
viscoses1338343viscoses
visitors1146433visitor_s
visored1138143vi_sored
visors92912223vi_sor_s
vitamers1334683vitamers
vitiators1246923vitiator_s
vittles103211113vi_ttles
vizored2034133vi_zored
vizors18328903vi_zor_s
vultures1137213vultures

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621127.42319690.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.88922650.7
 
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.