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

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

92 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
vertebrates169356(None) 
vertebrate15104081vertebrate_
cerebrates1447912cer_ebrates
invertebrates1862032invertebrates
vertebrae1472952vertebra_e_
vertebras1482672vertebra__s
celebrates1447673ce_lebrates
cerebrate1348653cer_ebrate_
cerebrated1546343cer_ebrated
deuterates1149083deute_rates
invertebrate1752223invertebrate_
perpetrates1566203perpetrates
reiterates10412003reite_rates
rerebraces1445033rer_ebraces
venerates12312263ve_ne_rates
vertebra1382563vertebra___
vertebral1472803vertebra__l
aerobrakes1643364aer_obrakes
aliterates101510764alite_rates
birthrates1545024birt_hrates
celebrate1348084ce_lebrate_
celebrated1556224ce_lebrated
cerebrals1354834cer_ebra_ls
deaerates10313644de_ae_rates
decerebrates1753594decerebrates
deliberates1446794deliberates
desecrates1348844de_secrates
deuterate1049514deute_rate_
deuterated1247534deute_rated
emeerates1149374_e_meerates
esterases949634_este_rases
execrates1839564_e_xecrates
exenterates1885374exente_rates
extenuates1744474_extenuates
extubates1844844_extub_ates
exuberates1945284_exuberates
federates13310154fe_de_rates
ferrates113013424fer___rates
firebrats1445884fir_ebrat_s
generates10312714ge_ne_rates
integrates111010784_integrates
iterates81317824__ite_rates
literates91415654_lite_rates
mercurates1446854mer_curates
meteorites1247614me_teorites
meterages1248184me_te_rages
overbrakes1946504over__brakes
overdecorates1953434overdecorates
overoperates17116614overoperates
overrates12414624over___rates
overtrades1457494overt__rades
penetrates1248724pe_netrates
perborates1459214per_borates
perennates1256764per_ennates
perforates1558864per_forates
permeates13311774perme__ates
perorates11417024per__orates
perpetrate1476654perpetrate_
perpetrated1675074perpetrated
perpetuates1584304perpetuates
perseverates1753154perseverates
porterages1345974porte_rages
preterites12411794prete_rites
rebates95123184__r_eb_ates
recrates102420374__r_ecrates
rectorates12410374rect_orates
regrates92618404__r_egrates
reintegrates1374944reintegrates
reiterate9412934reite_rate_
reiterated11410154reite_rated
reoperates1249664reope_rates
rerebrace1345394rer_ebrace_
reverberates1753514reverbe_rates
revibrates1546274re_vibrates
serrates82617024ser___rates
stearates939454__stearates
tartrates979564tart__rates
terneplates1353334terneplates
valerates12310544v_ale_rates
variegates1444044varie_gates
vegetates1346404ve_ge_tates
venenates1247584ve_ne_nates
venerate11312904ve_ne_rate_
venerated1339954ve_ne_rated
ventilates1347604vent_ilates
verbiages1544684ver__biages
veritates12310974ver__itates
vertexes18105634verte___xes
veterans1148854ve_te_ra_ns
vibrates132210614v___ibrates
vizierates2243244vizie_rates
wernerites1344944werne_rites

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 Filter1786911488190.420425454.8
2DLD Change Limit148819929.03316475.0
3Display Results92920.0631460.3
 (SQL Overall)178691929.51618778.0
 
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.