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

95 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
concertos13271113(None) 
concerto123311611concerto_
concerts123016061concert_s
conceits122813612conceit_s
concents122516602concent_s
concepts143110302concept_s
conceptus15295872conceptus
concerns122710832concer_ns
concert113325222concert__
concerted14312112concerted
concerti122912602concert_i
concertinos15158122concertinos
concretes13411472concretes
conversos1446892conversos
convertor1448782convertor
convertors1549132convertors
converts133213552convert_s
cancerous1367533cancerous
cancers114018583cancer__s
ciceros1158583c_icer_os
coexerts1734883coexert_s
conceals123111013conce_als
conceders1437953conceders
concedes13311053conce_des
conceit113218073conceit__
conceited14310423conceited
conceives1639233conceives
concent114422513concent__
concenter13312213concenter
concenters14410583concenters
concept133314443concept__
concepti14328273concept_i
conception16410453conception
conceptions17410593conceptions
concern113011963concer__n
concerned1438643concerned
concertgoer1672663concertgoer
concertgoers1752583concertgoers
concertina14410613concertina
concertinas15107553concertinas
concerting15313893concerting
concertino14910843concertino
concertize23169353concertize
concertizes24158583concertizes
conchos144313963conc__hos
concierges1544543concierges
concoctor1246323concoctor
concoctors1346403concoctors
concocts1138633concoct_s
concords1358593concor_ds
concrete12411083concret_e
concreted1439413concreted
concretion1449293concretion
concretions1549293concretions
concretism1655453concretism
concretist1448193concretist
concurs11311473concur__s
confects153110873confect_s
conferees14610623conferees
confers124120093confer__s
confervas1744823confervas
confetto1346253confetto_
congeries12316403congeries
congers104223233conger__s
congests113510383congest_s
conjuntos1844373conjuntos
conkers133721043conker__s
connector1347923connector
connectors1448183connectors
connects123010563connect_s
conners94023113conner__s
consents102715893consent_s
conserves14311193conserves
consorts101512343consort_s
contents104018213content_s
contests103413383contest_s
contexts17378653context_s
contorts101112643contort_s
contos84923233con___tos
convector1648083convector
convectors1768313convectors
convects153410993convect_s
convents132614603convent_s
converges1538373converges
converses14311163converses
converso1336423converso_
convert123721473convert__
converted15311563converted
converter14311013converter
converters1539633converters
countertop1445843countertop
countertops1546353countertops
coverts124813813co_vert_s
dolcettos1242433dolcettos
monteros1039453monter_os

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641957.23320550.4
3Display Results95950.0501900.0
 (SQL Overall)178691957.43924020.8
 
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.