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

83 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
previsit1341007(None) 
previsits1446791previsits
revisit10311371_revisit
prelimit1259122prelimit
previse123713792previs_e
prevised143611072prevised
previses133814282previses
prevising15510872prevising
prevision1448002prevision
previsited1645182previsited
previsor13116302previsor
revisits1137422_revisits
peevish1535783peevis_h
persist9315853persis_t
pietist9414033pietis_t
plenist9314333plenis_t
preadmit1346813preadmit
preaudit1177023preaudit
precast11314853precas_t
precinct1459423precinct
preciosity1754633preciosity
precis103416703precis__
precise113518173precis_e
precised133213413precised
preciser123411663preciser
precises123218333precises
precisest13259003precisest
precisian1347813precisian
precising14413273precising
precision13410053precision
precrisis1346453precrisis
predict12315323predi_ct
preedit10512463pre_edit
preexist1747963preexis_t
prefight1746393prefight
prelimits1366013prelimits
premise113818553premis_e
premised133013193premised
premises123018273premises
premising14412413premising
premiss113513813premis_s
premixt183510663premi_xt
preriot9316413preri_ot
preset84430983pre__set
presidia1147273presidia
presidio1146153presidio
presift12312223presi_ft
presplit1247753presplit
prest75736353pre__s_t
preterit10315853preterit
pretest9517633pretes_t
prevail1238243prev_ail
prevent124016553prev_ent
preview1536473previ_ew
previews1634513previews
previous1337823previous
previsions1547733previsions
previsiting1745543previsiting
previsors14126483previsors
priviest132310313priviest
prohibit1547193prohibit
prosit85124593pr__osit
protist9320223protis_t
provision1447633provision
proviso1237313provis_o
provisos1336913provisos
provost1238573provos_t
relist64628413_relis_t
reposit9315863_reposit
resist64524533_resis_t
resit54241043_re__sit
revest94623603_reves_t
revisal1038263_revisal
revise94019743_revis_e
revised113815483_revised
reviser104114663_reviser
revises104220533_revises
revising122714403_revising
revision1138713_revision
revisited1346573_revisited
revisor10388733_revisor
revuist1038473_revuis_t
visit8320963___visit

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 Filter1786911461620.423422437.4
2DLD Change Limit146162838.22017781.3
3Display Results83830.0461804.3
 (SQL Overall)178691838.68920565.2
 
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.