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

55 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
outvalues124430(None) 
outvalue1144231outvalue_
outvalued1344201outvalued
devalues1235853_devalues
disvalues1344503disvalues
misvalues1444683misvalues
outages82317323out_a_ges
outargues1044873outargues
outbakes1439993outba_kes
outblazes2085443outblazes
outbulges12134743outbulges
outcalls1038743outcal_ls
outcastes11118903outcastes
outdances12198503outdances
outdares92712463outda_res
outdates93114743outda_tes
outfables1485563outfables
outfaces132311393outfa_ces
outfalls1138143outfal_ls
outflies11310153out_flies
outgasses1036663outgasses
outgazes18248713outga_zes
outglares1047003outglares
outhauls1137223outha_uls
outlies72421993out__lies
outpaces122411943outpa_ces
outpasses1146613outpasses
outplaces1347743outplaces
outraces102217863outra_ces
outrages92215933outra_ges
outraises9311023outraises
outrances112912113outrances
outranges102510013outranges
outrates82421373outra_tes
outraves112313833outra_ves
outsoles8813113outsol_es
outtakes12310033outta_kes
outtalked1445513outtalked
outtalks1236503outtal_ks
outvaluing1444223outvaluing
outvaunt1145133outva_unt
outvaunts1242743outvaunts
outvies102214243outv__ies
outvoices1444423outvoices
outvotes1137903outv_otes
outwalked1745293outwalked
outwalks1535993outwal_ks
outwashes15116183outwashes
outwastes12127693outwastes
outwiles1139233outwil_es
overvalues1644963overvalues
prevalues1445323prevalues
revalues1137883_revalues
unvalued1266313_unvalued
values94314943___values

Search took 7 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.420425454.8
2DLD Change Limit148641556.17324079.2
3Display Results55550.0163437.5
 (SQL Overall)178691556.60927037.5
 
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.