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

57 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
outvalue114423(None) 
outvalued1344201outvalued
outvalues1244301outvalues
devalue1136013_devalue
disvalue1244433disvalue
misvalue1344683misvalue
outage72017533out_a_ge
outargue945093outargue
outate62923403out_a_te
outbake13310773outba_ke
outblaze1996013outblaze
outbulge11134753outbulge
outcall9310123outcal_l
outcalls1038743outcalls
outcaste10119613outcaste
outdance11238733outdance
outdare83113403outda_re
outdate83016423outda_te
outfable1378813outfable
outface123011973outfa_ce
outfall1039683outfal_l
outfalls1138143outfalls
outgave11259563outga_ve
outgaze17239223outga_ze
outglare937383outglare
outhaul1039063outha_ul
outhauls1137223outhauls
outlie62419533out__lie
outpace112613023outpa_ce
outplace1257913outplace
outrace92418553outra_ce
outrage82616893outra_ge
outraise8311933outraise
outrance102212773outrance
outrange92410223outrange
outrate72323183outra_te
outrave102614413outra_ve
outsole71013433outsol_e
outtake11310793outta_ke
outtalk1138233outtal_k
outtalked1445513outtalked
outtalks1236503outtalks
outvaluing1444223outvaluing
outvaunt1145133outvaunt
outvie92412803outv__ie
outvoice1344793outvoice
outvote1038803outv_ote
outwalk1437623outwal_k
outwalked1745293outwalked
outwalks1535993outwalks
outwaste11147943outwaste
outwile10310263outwil_e
overvalue1545443overvalue
prevalue1345073prevalue
revalue1038153_revalue
unvalued1266313_unvalued
value85719093___value

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.1561145455.1
2DLD Change Limit146162578.14317949.4
3Display Results57570.0301900.0
 (SQL Overall)178691578.32921454.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.