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

66 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
gerberas114496(None) 
gerbera1034771gerbera_
berberis1246602berberis
verbenas1345342verbenas
barbers114317503barber_s
berberin1246563berberin
berberins1346713berberins
bergeres1189113bergeres
beriberis1343523beriberis
berserks1433993berserks
carboras12311583carboras
cerebra1155923cerebra_
cerebral1266183cerebral
cerebrals1354833cerebrals
cervelas1344673cervelas
cervezas2242013cervezas
curbers115514383curber_s
embers104116183_ember_s
forbears1337073forbears
gabbers124612833gabber_s
garblers113810283garbler_s
garners83815983garner_s
garters84218233garter_s
geezers17286513geezer_s
gelders93812573gelder_s
genders93616783gender_s
genera71211713ge_nera_
general81010933ge_neral
generals9109333ge_nerals
genevas1185253ge_nevas
gerbils1037303gerb_ils
gerents82612923ger_ents
germens1078633germe_ns
getters84216103getter_s
geysers1135703geyser_s
gibbers124710983gibber_s
gibers95114663g_iber_s
gilberts1134183gilberts
girders9379943girder_s
goobers10219623goober_s
gorgers94813643gorger_s
grebes93813613grebe__s
herders113914123herder_s
hetaeras1146733hetaeras
jerboas1636163jerb_oas
jerkers18287083jerker_s
members13258603member_s
mercers114412773mercer_s
mergers103813423merger_s
overbears14208483overbears
perverts1337533perverts
sergers83815633serger_s
seriemas1047193seriemas
servers103214833server_s
sherberts1443593sherberts
temperas12278233temperas
terbias9310743terb_ias
termers95414503termer_s
terras63516973ter__ras
verbena1235373verbena_
vergers114412633verger_s
versers103813523verser_s
vertebras1482673vertebras
webers11310943we_ber_s
yerbas11119293yerb__as
zebras1737853ze_b_ras

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.423422437.4
2DLD Change Limit146162667.59319249.6
3Display Results66660.0164125.0
 (SQL Overall)178691668.03222247.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.