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

54 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
acquiring214448(None) 
acquitting2243652acquitting
enquiring19175442enquiring
esquiring19174022esquiring
inquiring19155642inquiring
lacquering2243602lacquering
quiring17159992__quiring
reacquiring2352652reacquiring
requiring1937042requiring
squiring18177562_squiring
abjuring1834883abju_ring
accoutring1543623accoutring
accusing1336783accu_sing
acquaint1945723acqu_aint
acquainting2352393acquainting
acquiescing25111433acquiescing
acquire1835603acquir__e
acquired2044043acquir_ed
acquiree1944603acquir_ee
acquirees2043103acquirees
acquirer1944093acquir_er
acquirers2043413acquirers
acquires1945403acquir_es
actuating1239233actuating
adjuring1735103adju_ring
admiring1236133a_dmiring
aequorin1743483aequorin_
aequorins1843273aequorins
airing74927503a___iring
alluring939073allu_ring
aquiline1746873a_quiline
aspiring1138873a_spiring
assuring937773assu_ring
attiring939483a_ttiring
auguring1036383augu_ring
backfiring2243803backfiring
chairing143110773_chairing
choiring14279793_choiring
churring14298653_churring
cruising112610153_cruising
curing94824783_c_u_ring
curring103616843_c_urring
hachuring1845123hachu_ring
lacqueying2551793lacqueying
liquoring1943703liquoring
occurring1443693occurring
quirking22215123__quirking
quirting18238383__quirting
requiting1939883requiting
scouring112810853scou_ring
sequining1945323sequining
squaring18158633_squaring
squirming2143223_squirming
squirting1934793_squirting

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.606294869.6
2DLD Change Limit148641547.20320636.0
3Display Results54540.0331636.4
 (SQL Overall)178691547.84222786.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.