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 “rubies” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
rubies8442034(None) 
rabies85226021rabies
rubbies114114111rubbies
rubes74928411rub_es
rubied94312411rubied
rubier84814741rubier
rubiest92914421rubiest
rubles83921701rubles
rugbies10339351rugbies
babies106123652babies
brumbies1436532brumbies
bubbies103913512bubbies
bubkes144612622bubkes
buboes104513992buboes
buries84633272buries
busbies113011692busbies
busies85525262busies
cubbies133312882cubbies
cubes95028162cub_es
cubics123810162cubics
cubits103714032cubits
curies84934022curies
cuties84927362cuties
dobies94422092dobies
duties74921902duties
furies95126372furies
gabies93820732gabies
gobies95418062gobies
hubbies143211562hubbies
jubes145420742jub_es
jubiles16289372jubiles
juries134120632juries
krubis1235002krubi_s
lubes74727992lub_es
lunies64723012lunies
nubias8310092nubias
nudies75217092nudies
pubes94423402pub_es
pubis94616472pubi_s
qubits173710352qubits
rabbies113416052rabbies
ramies84630462ramies
rebbes10313532rebbes
rebids94015532rebids
relies65036422relies
reties65436192reties
ribes75530172rib_es
ribier84414232ribier
ribiers9319752ribiers
robes75133302rob_es
robins83617452robins
robles85321692robles
roubles93413512roubles
rubaces1139312rubaces
rubbed114515082rubbed
rubber104715792rubber
rubbers113913192rubbers
rubbles113715112rubbles
rube65532012rub_e_
rubel75416832rub_el
rubels84112992rubels
rubigo935052rubigo
rubigos1033652rubigos
rubious938282rubious
ruble74521252ruble_
rubrics1177092rubrics
rubs66133492rub__s
rubus76415062rub_us
ruches114819582ruches
rues46044482ru__es
ruffes124112422ruffes
ruins55822032ru_ins
rules55234252ru_les
rulier65016352rulier
ruliest72816432ruliest
rumbles114018392rumbles
rummies113212792rummies
runes55530222ru_nes
rupees8312572rupees
ruses56136582ru_ses
rushes94724362rushes
rutiles74315842rutiles
rutins63818392rutins
tobies84521022tobies
tubes74826452tub_es
urbias839092urbias

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit82551862.68630733.8
3Display Results86860.0332606.1
 (SQL Overall)178691863.07958035.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.