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

60 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
incenter102212091incenter_
incenters112510301incenters
incented112412542incente_d
indenter92311442indenter_
indenters102710032indenters
inventer112410842inventer_
inventers12269532inventers
ancienter1145393ancienter_
ancientest1255373ancientest
center84421413__center_
centers94420603__centers
concenter13312213concenter_
concenters14410583concenters
decenter112412163decenter_
decenters122410373decenters
decentest1249083decentest
incanted11259543incante_d
incense92410303incense__
incensed11277953incense_d
incenses102411003incense_s
incent83320723incen___t
incenting12912063incenting
incentive1489603incentive
incents92414533incent__s
incepted13177773incepte_d
inceptor1246023inceptor_
inceptors1345773inceptors
inciter93113773inc_iter_
inciters103210673inc_iters
indecenter1345023indecenter_
indecentest1454733indecentest
indented101811733indente_d
indentor9288513indentor_
indentors10278313indentors
indenture1045063indenture
inexpert1746083in_expert
infecter13229153infecter_
infecters14257583infecters
infester11239433infester_
infesters12237713infesters
innocenter1252903innocenter_
innocentest1353813innocentest
insentient1049423insentient
inserter82312133inserter_
inserters92210283inserters
insetter8218593insetter_
insetters9187133insetters
intender93310443intender_
intenders10219373intenders
intenser8199443intenser_
intensest949103intensest
interterm1148813interterm
invented122510663invente_d
inventor11298153inventor_
inventors12288253inventors
inventory15255633inventory
inverter112411073inverter_
inverters12239753inverters
recenter102715443recenter_
recentest11410283recentest

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 Filter1786911486410.453394461.4
2DLD Change Limit148641607.53019739.8
3Display Results60600.0163750.0
 (SQL Overall)178691607.99922339.2
 
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.