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

53 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
arugolas94440(None) 
arugola844351arugola_
arugulas943911arugulas
rugolas836371_rugolas
areolas71013862ar_eolas
argalas84011092ar_galas
argols74514612ar_gol_s
arugula843912arugula_
aureolas846852aureolas
plugolas1143132plugolas
rugola736292_rugola_
rugosas844972_rugosas
acerolas1048053acerolas
aerugos834923aerugo__s
agoras7613343a__goras
ajugas1435263ajug__as
angoras8811363a_ngoras
ararobas1046183ararobas
areola6813673ar_eola_
areolae7811733ar_eolae
areolar779223ar_eolar
areoles71016953ar_eoles
argala74712673ar_gala_
argalis84214193ar_galis
argals75517713ar_gal_s
argils75213623ar_gil_s
argles75218483ar_g_les
argol65317263ar_gol__
argons75018203ar_go_ns
argots74116033ar_go_ts
argyles1136053ar_gyles
argylls1143463ar_gylls
armholes1347383armholes
armillas1046663armillas
aromas81018613ar__omas
arrobas969213ar_robas
aureola747033aureola_
aureolae845313aureolae
aureoles838283aureoles
auroras7311703a_uroras
crapolas1247403crapolas
cupolas11277753_cupolas
dongolas1045343dongolas
erugos7347343erugo__s
granolas938053granolas
marigolds1343083marigolds
parabolas1347003parabolas
pergolas1158233pergolas
plugola1043013plugola_
rubeolas10154853_rubeolas
rugosa734563_rugosa_
rugous739653_rugo_us
variolas1168533var_iolas

Search took 10 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.456391866.2
2DLD Change Limit146162538.57617043.1
3Display Results53530.0163312.5
 (SQL Overall)178691539.04819749.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.