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

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

81 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
concertgoings196167(None) 
concertgoing1852621concertgoing_
concertgoers1752583concertgo_ers
concertinas15107553concert__inas
concerting15313893concert__ing_
concertinos15158123concert__inos
concertizing2655633concertizing_
conceiting15311774conceit__ing_
concentering1755434concentering_
conceptions17410594conceptio_n_s
concerning1548904concer__ning_
concertgoer1672664concertgo__er
concertina14410614concert__in_a
concertino14910844concert__in_o
concertizes24158584concert__izes
concertos132711134concert_o___s
concreting1539874concret__ing_
concretions1549294concretio_n_s
concretizing2654304concretizing_
conferencings2161804conferencings
converging1758094conver_g_ing_
converting16313134convert__ing_
operagoings1551674_o_peragoings
centerings13247665center___ings
coexerting2045495coexert__ing_
concealing1549305conce__aling_
conceding1559345conce___ding_
conceiving1846775conce__iving_
concentrating1856435concentrating_
conception16410455conceptio_n__
conceptional1856915conceptio_nal
concernments1865245concer_nments
concerns122710835concer____n_s
concertedness1855835concertedness
concerti122912605concert__i___
concertize23169355concert__i_ze
concertized25146365concert__ized
concerto123311615concert_o____
concerts123016065concert_____s
concessions15128105concessio_n_s
concocting1448415concoct__ing_
concoctions1448255concoctio_n_s
concretion1449295concretio_n__
concretisms1764435concret__isms
concretists1555465concret__ists
concretizes24166005concret__izes
concurring1546605concur__ring_
confecting18310555confect__ing_
confections18411395confectio_n_s
conferencing2053855conferencing_
conferring1648745confer__ring_
congesting14410115congest__ing_
congestions1449315congestio_n_s
conjecturing2452795conjecturing_
connecting15310385connect__ing_
connections15410705connectio_n_s
consenting13313225consent__ing_
conserving1639765conser__ving_
consorting13410745consort__ing_
contenting13313325content__ing_
contentions13412095contentio_n_s
contesting13312215contest__ing_
contorting13410105contort__ing_
contortions1348685contortio_n_s
convecting18310435convect__ing_
convections18411495convectio_n_s
conventing16311545convent__ing_
conventions16410535conventio_n_s
conversing16310545conver__sing_
conversions1648275conversio_n_s
convertors1549135convert_o__rs
conveyancings2461215conveyancings
counterpoints1755625counter_points
coverings15217895co_ver___ings
moviegoings185845movie__goings
nonmeetings1453005nonmeet__ings
oceangoing1441595_o_ceangoing_
operagoing1443585_o_peragoing_
outgoings1143955_o___utgoings
undergoing1347085_under_going_
undertakings1894035_undertakings

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 Filter1786911247900.390458182.1
2DLD Change Limit124790818.64314438.3
3Display Results81810.0461760.9
 (SQL Overall)178691819.07919681.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.