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

101 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
ovisac115395(None) 
ovisacs1263281ovisacs
visa76323872_visa_
visas84317652_visas
anisic8313793anisic
avian84616053avi_an
aviso85713963avis_o
avisos95410483avisos
corsac10410173corsac
crisic103611843crisic
devisal1136913devisal
disc76123233_dis_c
dovish1338103dovis_h
fisc96819753_fis_c
iliac75013493ili_ac
jovial1636543jovi_al
lilac7311073_lilac
linac7315413_linac
misact10316693_misact
obia67923113obi_a_
obias76116863obi_as
obis66226843obis__
ocicat101412813ocicat
odic74920573odi__c
odist6421913odis_t
odists749853odists
ogival1035873ogival
ohia75719363ohi_a_
ohias84415573ohi_as
omasa749483omasa_
oomiac1037063oomiac
orgiac934993orgiac
origan7310693origan
orisha936773orisha
orishas1036473orishas
orison6411663orison
osar46820953o__sar
ossa43714163o_ssa_
ossia53710403ossia_
otic66624823oti__c
otitic83112683otitic
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
ova66823793ov__a_
oval77119523ov__al
overact12315043overact
oversad11259963oversad
oversaw13268163oversaw
ovibos1145463ovibos
oviduct1343443oviduct
ovine86316643ovi_ne
ovines94614343ovines
ovipara1242543ovipara
ovoidal1144023ovoidal
ovonic11288183ovonic
ovular946833ovular
oxidic1635943oxidic
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
ptisan8417973ptisan
revisal1038263revisal
sac57452863___sac
sisal54217733_sisal
triac74116373tri_ac
umiac938963umi_ac
vac86537143_v__ac
vasa76522973_vasa_
vasal85516293_vasal
via65636243_vi_a_
vial76731093_vi_al
vicar10513863_vicar
viga85622963_viga_
vigas94817883_vigas
vina76331803_vina_
vinal85725813_vinal
vinas85126343_vinas
vinca105315163_vinca
vinic10314973_vinic
viral86419593_viral
vis66747613_vis__
visaed104110503_visaed
visage1049083_visage
visard103910123_visard
vise75632673_vis_e
vised95518763_vised
vises84427773_vises
visit8320963_visit
visor82512833_visor
vista85416603_vista
vistas94513273_vistas
visual938803_visual
vita75828523_vita_
vitae84217633_vitae
vital84819673_vital
viva106119093_viva_
vivace1436553_vivace
vivas114815023_vivas
voila84813943voila_
zodiac1835303zodi_ac

Search took 6 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.466383457.1
2DLD Change Limit1127161015.04622337.7
3Display Results1011010.0333060.6
 (SQL Overall)1786911015.54532225.6
 
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.