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 “visitor” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
visitor104620(None) 
visiter1038861visiter
visitors1146431visitors
viator93211842vi_ator
victor113210672vi_ctor
vision9311312visi_on
visit8320962visit__
visited1168772visited
visiters1137412visiters
visits9311422visit_s
visor82512832vis__or
vitiator1147042vitiator
assistor844823assistor
auditor837313auditor
aviator10229683avi_ator
avigator12236783avigator
bisector1245193bisector
bister84922763bis_ter
bistort91216523bis_tort
bistro8339943bis_tro
castor84418533cas_tor
citator9310123citator
dilator82712793dilator
dilutor8256013dilutor
dinitro845563dinitro
disinter9310673disinter
distort81120333dis_tort
divisor11345573divisor
editor738663_editor
elicitor1045773elicitor
evictor12346373evi_ctor
excitor1645993excitor
finito9310303finito_
genitor837273genitor
heritor10310563heritor
history1339423his_tory
ignitor8125263ignitor
janitor1436483janitor
lictor83610863li_ctor
limiter92710853limiter
lister64527253lis_ter
misinter1038833misinter
misstop11156413misstop
mister84728563mis_ter
mistier93418713mistier
mistutor1044943mistutor
monitor9310723monitor
nestor63713423nes_tor
ovipositor1551673ovipositor
pastor84817483pas_tor
pinitol936683pinitol
piscator1246923piscator
pisiform1564973pisiform
pistol83313333pis_tol
piston83515923pis_ton
pistou83211843pis_tou
resistor847683resistor
simitar936733simitar
sister64421583sis_ter
sitar54820543__sitar
suitor63311053_suitor
traitor7310123traitor
vanitory1445733vanitory
varistor1146393varistor
vasiform1644243vasiform
vaster94521023vas_ter
vastier103613203vastier
vector113212063v_ector
viators102712033vi_ators
vibrator13227353vibrator
victors123311183vi_ctors
victory15326983vi_ctory
vidicon1343783vidicon
vigor92612423v__igor
vinier93716743vini_er
violator1146283violator
virion9310683viri_on
visible1236923visible
visibly1535043visibly
vising103915873visi_ng
visions10311023visions
visitant1147363visitant
visiting1238393visiting
visive1257873visi_ve
visors92912223vis__ors
vista85416603vis_t_a
vistas94513273vis_tas
vitiators1246923vitiators
vivider14265623vivider
vizier184311023vizi_er
vizir17359393vizi__r
vizor173010093v__izor
vomiter1237953vomiter
vomito11238033vomito_
vomitory1644413vomitory
vomitos12217103vomitos

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.420425454.8
2DLD Change Limit134027966.56320421.6
3Display Results96960.0332909.1
 (SQL Overall)178691967.01625469.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.