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

79 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
previsors1412651(None) 
previsor13116321previsor_
revisors11379071_revisors
devisors12347252_devisors
pressors103212702pre_ssors
previous1337842previ_ous
previses133814292previs_es
previsions1547742previsions
previsits1446812previsits
promisors13236362promisors
provisoes1446652provisoes
provisory1744352provisory
provisos1336922proviso_s
revisers113511942_revisers
revisor10388742_revisor_
revisory14306022_revisory
advisors12143903_advisors
breviers1335943brevi_ers
creditors1245883creditors
devisers12339863_devisers
devisor11357043_devisor_
divisors12255693_divisors
improvisors1882513improvisors
paviors1237613p_avi_ors
pavisers13387443p_avisers
pervious1337543pervi_ous
plessors10278263ple_ssors
poetisers1145313poetisers
praisers103410843pr_aisers
preabsorb1542863preabsorb
preabsorbs1652063preabsorbs
precensors1445463precensors
precious12310603preci_ous
preciser123411663preciser_
precises123218333precis_es
precisions1449373precisions
precursors1442813precursors
predators12310103predators
predictors1547273predictors
prehistory1845343prehistory
prelusory1442883prelusory
premiers122911653premi_ers
premises123018273premis_es
premiss113513823premis__s
premisses13288763premisses
presiders1248223presiders
presort95219553pre__sort
presorts105311693pre__sorts
pressers103215033pre_ssers
pressor93512893pre_ssor_
pretors9316823pre__tors
prevailers15123833prevailers
previewers1842563previewers
previews1634523previ_ews
previse123713803previs__e
prevised143611083previs_ed
prevising15510873prevising
prevision1448013prevision
previsit13410083previs_it
priors83914483pr__i_ors
prisons9313233pr__isons
promisers13268203promisers
promisor12266183promisor_
providers1535593providers
provisions1547213provisions
proviso1237313proviso__
resistors948003_resistors
revilers114011703_revilers
revisals1136823_revisals
reviser104114673_reviser_
revises104220543_revis_es
revisions1238603_revisions
revisits1137433_revisits
revivers14389643_revivers
seisors73212843_se_isors
servitors1245223servitors
supervisors1653713supervisors
televisors1352243televisors
visors92912223___visors

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.423422437.4
2DLD Change Limit148641797.71619264.0
3Display Results79790.0501580.0
 (SQL Overall)178691798.18921820.9
 
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.