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

67 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
bartisan105616(None) 
artisan759461_artisan
bartisans1165551bartisans
bartizan1954411bartizan
partisan1058421partisan
artisans888522_artisans
barbican1445342barbican
bartizans2053702bartizans
bipartisan1452042bipartisan
martian93514682marti_an
partisans1167482partisans
partizan1955642partizan
antiman9313883_antiman
antisag838043_antisag
arisen65316793_ar_isen
artisanal983823_artisanal
artist64125543_artis_t
artiste73813693_artiste
artists74215593_artists
banian8315383ba_ni_an
baptise1139553baptis_e
baptised1335263baptised
baptises1238923baptises
baptisia1245013baptisia
baptisias1344303baptisias
baptising1446093baptising
baptism1337803baptis_m
baptismal1542293baptismal
baptisms1446033baptisms
baptist11311873baptis_t
baptists1236723baptists
barbicans1544483barbicans
barbital1247053barbital
barchan1469133bar_chan
bargeman1345143bargeman
barista9310813bar_ista
baristas1039723bar_istas
barman103519703bar__man
bastion9312473basti_on
batiste939743ba_tiste
batman105214063ba_t_man
batsman1157993ba_tsman
brisant9312683b_r_isant
cardigan1245613cardigan
earthman1346473earthman
garrison943983garrison
harijan1735783har_ijan
harridan12145123harridan
larrigan944213larrigan
martial92415413marti_al
martians103111613marti_ans
martin84122523marti__n
marzipan2142693marzipan
paisan84417073pa__isan
parian83223963par_i_an
parmesan1244753parmesan
partan83820563part__an
partial92616263parti_al
partisanly1543463partisanly
partita9310863partita_
partitas10310253partitas
partizans2055243partizans
ptisan8417973__ptisan
tartan64217513tart__an
tartish101512633tartis_h
tertian7511193terti_an
warison1037083war_ison

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 Filter1786911461620.330541487.9
2DLD Change Limit146162676.84321359.3
3Display Results67670.0332030.3
 (SQL Overall)178691677.20624797.5
 
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.