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

68 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
qiviut184661(None) 
qiviuts1942891qiviuts
binit76431583bini_t
cilium104311373cilium
civet105828733civ_et
civic123412543civi_c
civics13397823civics
civie103716353civi_e
civies114116443civies
civil103411933civi_l
civism1337243civism
davit93424593davi_t
devout10712993devout
digit73825273digi_t
dimout9414243dimout
divert103922813divert
divest106820073divest
divide113410893divide
divine103514463divine
diving113717953diving
divot95723073div_ot
dixit134420593dixi_t
evict104417143_evict
fixit154819303fixi_t
giving114313883giving
hiving134115523hiving
idiot6718863_idiot
ilium74614183_ilium
input7314653_input
ivied94710523_ivied
ivies84215763_ivies
jivier16438613jivier
jiviest1738113jiviest
jiving173711603jiving
licit74327683lici_t
limit73126343limi_t
livest95315733livest
livid96714423livi_d
livier97514593livier
living104318323living
midgut103510053midgut
milium104712683milium
minium106014423minium
miscut10614823miscut
oidium959813oidium
pignut9311573pignut
pigout9314613pigout
pipit95224873pipi_t
pivot106523873piv_ot
quaint15415173quaint
qubit164218993qubi_t
quiet144530733q_uiet
quilt144125103q_uilt
quint144529903q_uint
quirt144624233q_uirt
quit136136513q_ui_t
quoit143819863quoi_t
rivet85636363riv_et
riving104521423riving
soviet9720153soviet
trivium1256143trivium
vibist11610583vibist
visit8320963visi_t
vivid125112313vivi_d
vivify1834703vivify
wikiup15183533wikiup
wiving133316603wiving
zizit13313273zizi_t

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.376475242.0
2DLD Change Limit112716684.81023433.7
3Display Results68680.0164250.0
 (SQL Overall)178691685.20234350.4
 
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.